SQL (structured query Language, Structured Query language)
db→ database, storing data files
DBMS (Database Management system, DB management systems), including DB and management software
dbs→ database system, including DBMS, hardware device, operator
The database is divided into three levels
1. library files (for storing data)
Database file storage location (I chose to install the F drive when I installed it)
Database files are divided into two types:
1), data file (suffix. mdf) for storing data
2), log file (. ldf), used to record the operation of the database, many times the log file is larger than the data file, affecting the database operation, need to periodically clean up
2, service. When you open the database management interface, the selected database engine is the service.
3. Management interface
When doing development, the general server authentication method is (SQL server Authentication ), but when the installation, choose (Windows authentication ), then how to modify, as follows steps:
Press two to finish, you need to restart the service, right-click the instance (first of the two graphs), then select Restart
Enable SA account (SA account is the system administrator account with the highest permissions to operate the database)
Accessing other computer-side databases
Getting Started with 140901 databases, changing authentication methods