SQL Server Backup Recovery example

See note. youdao. comshare for the complete documentation? Id1_97a96387e903c407efa7323a39b81typenote we want to back up the AIS20130321193629 database and then restore it on the test machine. 1. Right-click the database-task-Backup 2. Select full backup. Write a brief introduction to the backup name and specify the path. In the backup

See: http://note.youdao.com/share? Id = 97a96387e903c407efa7323a39b81type = note: We want to back up the AIS20130321193629 database, and then restore it on the test machine. 1. Right-click the database-task-Backup 2. Select full backup. Write a brief introduction to the backup name and specify the path. In the backup

See: http://note.youdao.com/share? Id = 97a96387e903c407efa7323a39b81 & type = note

We want to back up the AIS20130321193629 database and restore it on the test machine.

1. Right-click the database and choose task> Backup.

2. Select full backup. Write a brief introduction to the backup name and specify the path.

After the backup is complete, go to F: \ k3backup to find the AIS20130321193629-20140530.bak file and check whether it exists and the size.
And then transfer it to the testing machine.

Restore on the Test Machine
1. Do not choose to stay on the database to be restored. You can choose to use master.

2. Right-click the database and choose task> restore> database.

3. Select the backup file.

4. Add permissions.
After the database is recovered, the corresponding user permissions of the database in production will be lost. We need to re-accept k3reader to grant db_owner permissions.