SQL Server 2005 Recovery database detailed graphics tutorial

Many need to use the SQL2005 program, there are many novice or will operate, here to write a detailed picture and text tutorial to send a rookie, master please drift over. For standalone host friends use, if you haven't installed, follow this tutorial to install the SQL Server 2005 Graphics Installation tutorial, super detailed

The following is a detailed procedure for SQL Server 2005 Recovery Database

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

2. Right-click Database--New database

3; pop out the box, fill in the database name, I fill in here is sqlqtdy, this according to their own needs to fill, the other default, and then click OK

4; For security, we also need to create a separate database user name. Expand the following security, right-click the login name, click New Login

5. Login name fill Well, I am here instance 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 there select the database that we just built, I am here an example of SQLQTDY

6. Don't make sure, just click on the top left side of the dialog box, user mapping

7. Next, the user mapped to this login, find the database we just built, with the mouse first point two down that data, and then tick the database, and then check the db_owner and public

OK, then.

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

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

Click the box next to

10. Click Add

11. Find us the backup file to restore the database, file type Select all Files

Make sure after you choose.

Here, go ahead, OK.

12. Go back to the interface and click the option, tick overwrite existing database

then click OK.

This database has been restored to completion

Original: http://www.codesocang.com/jiaocheng/shujuku/2014/0515/7706.html