Model, Component, and Package Management > Model management > Model Explorer > Working with databases > Restoring a database (Model Explorer)
Restoring a database (Model Explorer)
You can only restore a database if Model Explorer is running on the same machine as the SQL Server instance.
1. Start Model Explorer.
Starting a 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: