Restoring a Database
 |
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 2017 database to SQL Server 2019, but you cannot restore an SQL Server 2019 version database in to SQL Server 2017.
|
You can restore a database by using one of the following tools:
• Model Explorer
• ScfUtils command line interface
• Model Manager
• SQL Server Management Studio
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.
ALTER DATABASE [database_name] SET COMPATIBILITY_LEVEL = (SELECT compatibility_level FROM sys.databases WHERE name = N'master');
USE [Modeler_Admin];
EXECUTE dbo.[spAdminScanDatabases];
USE [Modeler_Admin];
EXECUTE dbo.[spAdminScanDatabases];
After you restore the databases, you must execute all steps listed in the Migrate All Databases topic.