Basic knowledge of the database

Database: A program used to access data.

Access,sql server,mysql,oracle

Databases: Services, interfaces

When storing data, the database is also used as a tabular method:

Column (field):
Line (record):

To create a database:
Main file: There is only one. mdf
Log file:
Secondary data files:. ndf

Attaching and detaching a database
Detach: Locate the database, right-click-Task-Detach, Pop-up dialog, click OK
After the separation, you can copy the database files to other computers D:\Program Files\Microsoft SQL Server\mssql10. Mssqlserver\mssql\data
Attach: Select database, right--Attach--Popup dialog--select attached file--click Add to find the file to attach--ok

Backup and restore of databases

Basic knowledge of the database