Restoring a Database (SSMS)
 |
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 in to SQL Server 2019.
|
Restoring a database using SSMS
For more information on restoring databases from SSMS, see Restore a Database Backup Using SSMS.
After restoring databases, you must run the following query. This query scans and lists existing Modeler databases in Model Explorer.
USE [Modeler_Admin];
EXECUTE dbo.[spAdminScanDatabases];
You can also restore a database by using any of the following tools:
• Model Explorer
• ScfUtils command line interface
• Model Manager
After you restore the databases, you must execute all steps listed in the Migrate All Databases topic.