SQL Server 2008 RESTORE Database

1. Get the database backup file, how to get it, [can see here]~

2. Add a. bak suffix to the backup file, for example:

3. Open SQL, you can create a new empty database, or use the original database, right-click >> Tasks >> Restore >> Database

4. The Restore Database dialog box appears, and on the general Selection page, do the following:

5. On the [Options] Selection page, do the following:

6. Directly Press OK (PS: Before the first time the restoration of the error occurred, I used the sa login, may be a permission problem error, and later with the Windows identity authentication only).

~

SQL Server 2008 RESTORE Database