SQL Server 2005 Restore database detailed graphics and text tutorial _mssql2005

Many need to use the SQL2005 program, there are a lot of novice or will operate, here to write a detailed picture and text tutorials to send a rookie, master please drift. For a friend using a stand-alone host, if you have not yet installed, follow this tutorial to install the SQL Server 2005 Graphics Installation tutorial, Ultra detailed

The following is a detailed procedure for SQL Server 2005 to recover a database

1. Open SQL Server Management Studio and log in, this is generally in the beginning-Program found

2. Right-click Database-New Database

3. Bounce out of the box, fill in the name of the database, I filled out here is sqlqtdy, this according to their own needs to fill out, the other default, and then point to determine

4. For security, we also need to create a separate database username. Expand the security below, right-click the login name, and click New Login

5. Login name filled out, I have here the example under the QTDY, now SQL Server authentication, do not check the mandatory password expiration and the user must change the password at the next logon, the following default database where we have just established the database, I here The example is the SQLQTDY

6. Do not point to determine, and then click on the left side of this dialog box, user mapping

7. Next to, the user mapping to this login, find the database we just set up, use the mouse to click the first two of the data, and then tick the database, and then check the next db_owner and public

Just to be sure.

8; Back to the database we established just now, I have here the example is Sqlqtdy, the right mouse click the database name, sqlqtdy--task--Restore--database

9. In the regular inside point, select the source device

Click on the box next to it

10; add more

11. Find the backup file that we want to restore the database, file type Select all Files

When you choose, you'll be sure.

Here, keep it fixed.

12. Back to the interface after the option, check the overwrite existing database

and then dot OK

To this database, the recovery is complete.