Restoring a database (Model Explorer)
 |
You must consider the following before restoring a database:
• You can restore a database only if Model Explorer is running on the same computer as the SQL Server instance.
• The database you are restoring can be from the current version or from an older version of SQL Server. However, you cannot restore the database that is from a later version of SQL Server. For example, you can restore an SQL Server 2017 database to SQL Server 2019, but you cannot restore an SQL Server 2019 version database into SQL Server 2017.
|
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:
|