A case of SQL Server Backup recovery



For complete documentation, please refer to: http://note.youdao.com/share/?id=42697a96387e903c407efa7323a39b81&type=note

We want to back up the AIS20130321193629 database and then do the recovery on the test machine.

1. Right-click the corresponding database-and-task backup

2. We select Full backup. Write a description of the name of the backup and indicate the path.

After the backup is complete, we go to F:\k3backup, find out the Ais20130321193629-20140530.bak file, confirm its presence and size.
It is then transferred to the test machine.

Recovery on the test machine
1. Do not choose to stay on the database you want to restore, you can choose use Master.

2. Right-click Database, Task----Restore Database

3. Select our backup file.

4. Add Permissions.
After recovery, the database in the production of the corresponding user rights will be lost, we need to re-accept K3reader grant db_owner permissions.