Restoring a Database
You can restore a database by using one of the following tools:
• Model Explorer
• ScfUtils command line interface
• Model Manager
• SQL Server Management Studio
 |
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.
|
If the database you are trying to restore exists in SQL Server, you may have to perform the following tasks:
• Delete the database.
• Use the Optimize command in Model Explorer to truncate the database log.
• Close Model Explorer, and make sure not to select the database from the list before running the Restore command.
For more information about restoring a database, refer to the following SQL Server Management Studio help topic:
Restore a Database Backup (SQL Server Management Studio)
|
|
The Restore command should be performed on the machine that is hosting the SQL Server instance. The restore command in Model Explorer and Model Manager is disabled if the PTC Modeler server is not local.
If you are using a remote machine to create a backup through ScfUtils, you should specify a UNC path for the backup file location. Local paths are relative to the PTC Modeler server, and not the remote machine.
|