Restoring a database (Model Explorer)
 |
You can restore a database only if Model Explorer is running on the same computer as the SQL Server instance.
|
1. Start Model Explorer.
2. In the left navigation pane, expand the SQL icon.
3. Right-click on a Server that you want to a restore a database to.
4. Click Restore Database....
5. In the Restore dialog box, specify a .bak backup file to restore from and click OK.
6. Confirm that the Database Restored Successfully message appears, and then click OK.
|
|
Make sure the Windows account which runs the SQL Server service has access permissions to the backup destination folder.
For more information, refer to the Permissions section of the following SQL Server help topic:
|