Database Backup Restore Notes

Try to back up, restore on two different machines

SQL database backup database right--> task-> backup. In the Open Backup Database dialog box, click Delete First, then click Add, and in the Select Backup Destination dialog box, select the folder and file name (used when restoring).
SQL database Restore database right--> task-> restore. In the Restore Database dialog box that opens, select Original device, and then click the "..." button at the back.
In the Specify Backup dialog box that appears, click the Add button to add the. bak folder that you just backed up.
Possible error

It's not a problem to restore a lot of databases before, and this is the first step to set up a target database, then select the source file to restore. Finally made a mistake:

1, first of all, we should set up a target database before restoring the database, otherwise the system can not find the target database error.

2, right click--Restore the database

3, select the target database and source equipment.

4, check the backup set to restore, click Options to the Options page

5, check and overwrite the existing database.

6, the error may occur: Restore database prompts are in use

WORKAROUND: This database may be called in IIS and can be restored after IIS is closed ...
Workaround Two: Right-click the database "XX", then select Properties, select Options, and under Other options, find restricted access in status. Select "Single_user" and click "OK" button. Continue restore