Backing up a Database
 |
Ensure the following prerequisites are met before proceeding with database backup:
• Users should not own any schemas and roles in the database.
• Database collation should be Latin1_General_CI_AS.
|
You can create a backup by using one of the following tools:
• Model Explorer
• ScfUtils command line interface
• Model Manager
• SQL Server Management Studio
By default, Model Explorer, Model Explorer, ScfUtils, and Model Manager create backups using the SQL Server Full Backup mode. This mode takes a backup of the database at a given point in time, which allows full data recovery. You should take backups at regular intervals. To recover disk space, you can truncate logs after performing backups.
To achieve better performance for transaction-intensive workloads, use SSD drives.
For more information about Full Backups, refer to the following SQL Server help topic:
Create a Full Database Backup
|
|
Backups should be performed on the system that is hosting the SQL Server instance. The backup command in Model Explorer and Model Manager is disabled if the PTC Modeler server is not local.
If you are using a remote system 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 system.
The backup process does not include the ModelerATFiles folder. If you need the ModelerATFiles data, you should copy the folder manually.
|