Restoring a database through ScfUtils (Model Explorer)
 |
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.
• 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.
• 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.
|
ScfUtils provides a command line interface for performing Model Explorer functions.
You can restore a database through ScfUtils.
If you have installed Modeler to the default locations, ScfUtils resides in the following location:
<<INSTALLDIR>>\Modeler\Exe\SCFUtils.exe
For information about restoring a database through Model Explorer, refer to Restoring a database (Model Explorer).
Syntax:
ScfUtils -restoredb Enterprise "<instance-name>" "<backup-file>"
Where:
• <instance-name> specifies the SQL Server instance to restore a database to.
Type the instance name in the following format: server[@instance]
• <backup-file> specifies the backup file location.
Example:
ScfUtils -restoredb Enterprise "Server1@MODELER" "C:\temp\ModelsDB.bak"
After you restore the databases, you must execute all steps listed in the Migrate All Databases topic.