SQL Server Database Basics

First, the database three levels:

library files, services, management interfaces

Second, about the database of small knowledge:

DB: Refers to the file in which the database stores data
DBMS: Database management System
DBS: Database system, including people, machine hardware, DB and hypervisor
MDF: Master Data file
NDF: Secondary data file
IDF: Log files

Third, the SA account activation
Windows Authentication Login
authentication method for attribute security selection on service
Enable SA and set password
Restart Service
After reboot, try to connect with SA later

Iv. Backup

Right-click the database name you want to back up ———— task ———— backup

V. Separation

Right-click the database name to detach ———— task ———— Detach

Six, restore

Create a new database ———— name the newly created database ———— right-click the new Database ———— task ———— restore

Vii.. Additional

Right-click the database you want to attach ———— attach ———— Locate the file ———— add

Eight, import, export

Program ———— All Programs ———— SQL server ———— Import and export data ———— next

SQL Server Database Basics