Concepts of Backup and recovery:
Backup and recovery components are an important part of SQL Server. A backup is a copy of a SQL Server database and other related information, which records the state of all the data in the database when the backup is performed, and if the database is damaged, the backup files are used to recover the database when the database is restored.
Recovery is to restore the damaged, lost data or the wrong database to the original normal state, which is backed up by the decision.
Detach Database:
When SQL Server runs, it cannot be copied directly to the SQL Server database file in Windows, and if you want to replicate the SQL Server database files, analyze the database files from the SQL Server server so that you can replicate them.
Additional databases:
The task of attaching a database is to detach the inverse of the database, and by attaching the database, you can add a database file that does not join the SQL Server server to the server.
The difference between attaching, detaching a database, and backing up and Restoring a database (reproduced in Snow blog)
