SQL SERVER 2005 Database Restore Method _mssql2005

To restore a database under SQL SERVER 2005

1, new database A, right to restore the database, when the target database is a, select backup

File B_db_201311040200.bak, prompt on restore "database backup in Backup set is different from existing a database"

2, Google, some people say that the file name is different, that is, b database file for B.mdf,

To revert to A.mdf, so the error

3, delete a library, the root directory "database" on the right, restore the database, first select the source file,

B is then automatically found in the target database, and you can restore success after you select B

believe that many webmaster sites need to use the SQL Server 2005 database, but encountered some problems do not recover, I am a professional learning. Net. Usually also used, hope to bring help to everyone. The following is a detailed picture and text resume sharing.

1. Open SQL Server Management Studio and log in, (if your desktop does not have a shortcut, find it in the Start program)

This interface appears after opening, right click on the database, as shown:

2, pop-up dialog box, here to fill out their own definition of the database name (I fill in the Sqlqtdy), the other options set to the default, as shown:

3, generally for the sake of safety, here we need to create a user name, as shown in the figure:

4, login name to fill out (I fill in the Qtdy), the following needs to be done is SQL Server authentication, remember not to check the mandatory password expiration and the user must change the password at the next logon.

The following default database to select the database we have just established (SQLQTDY), as shown in the figure:

5, this time do not be anxious to determine, in the upper side dialog box to select, as shown:

6, the map after the successful appearance of this interface, with the mouse first point two under the database we have just established, and then tick in the following dialog box, respectively, tick db_owner and public two options, and then determine, as shown:

7, go back to just that interface right-click the database name we just established immediately after the image operation, the above painted black part of their previous database here will not reveal the hope of understanding.

8. Select the source device in the selection page General options, click on the button with the lower corner, as shown:

9, the next pop-up this interface, choose to add, as shown:

10, finally find the database we need to back up recovery (remember file type select all files), as shown:

After you choose, click OK, and you will return to the previous interface. This time we go back to the Select page, select the following figure:

Finally click OK, the database even if the recovery is complete. Hope that your own sharing will help you solve some of the problems.

End

Database this thing is to be careful, there is a point of error will be very troublesome.