SQL Server2005 data Restore and backup specific steps

One : backing up the database steps

1, the first step: at the beginning-> program (P)->microsoftsqlserver2005-> Sqlservermanagementstudio(e.g.)

2, the second step: Log on to the database server, after you open Enterprise Manager, expand, locate and expand the database, and then you will see the database that needs to be backed up "Gxbtoc" (for example)

3, the third step: Select the database to be backed up right-click (for example)

4, the Fourth step: click "Backup", enter (the general situation with the default setting is OK) (such as)

5. Fifth step: Click "Add"to go to the "Select Backup Destination" dialog box (e.g.)

6, Sixth step: Click "Select Backup Target" to the right of the three-point box to open the path of the backup file, see, in the "Locate Database Files" window to specify the directory and fill in the backup file name, then click OK, return to the "Backup directory" window.

7: Start backup (e.g.) after clicking "OK" when you really return to "backup directory".

8: Open Step v determine the drive letter you can see the backed up database (for example)

Second, restore the database steps

1, the first step: at the beginning-> Assembly (P)->microsoftsqlserver2005- >sqlservermanagementstudio(e.g.)

2, the second step: Log in the database server that needs to be backed up, after you open Enterprise Manager, expand each, see the database entry, select the database node right-click (for example)

3, the third step: select "Restore" into the "Restore Database" window, the target database has already selected to restore the data, and then in the "Source of Restore" select "Source Device (d)", click "Source device ( D) " Right" ... "button . See

4. Go to "Specify Backup dialog" and click "Add" to enter the specified database File window.

5, Fourth step: Browse and find the database backup files that need to be restored, click "OK"

6, the sixth step: click "OK" back to the "Fixed Backup" dialog box, the file needs to be restored is listed, and then click "OK", return "restore Database."

8. Select "Options" in the Function navigation box on the left and select "Force Restore on Existing database (F)" and click "OK".

SQL Server2005 data Restore and backup specific steps