Restoring a Database (Model Manager)
 |
You must consider the following before restoring a database:
• Only SQL Server Administrators and Modeler System Administrators can perform this task.
• 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 2019 database to SQL Server 2022, but you cannot restore an SQL Server 2022 version database into SQL Server 2019.
• When restoring a database, if the dbo user-linked login does not exist in the SQL Server Instance, then the user restoring the database becomes the dbo user of the database.
|
To restore a a database
1. Log in to Model Manager.
2. Right-click on the instance and select Perform Task.
3. On the Perform Task dialog box, select Restore.
4. Select Now to restore the database immediately and click Start.
5. Click Choose File to select the backup file path.
6. Click Restore.
7. Provide the database name (the name should be the same as that of the backup file). Click Restore.
After you restore the databases, you must execute all steps listed in the Migrate All Databases topic.