Backing up a database through ScfUtils
 |
• Backups can be performed only if Model Explorer is running on the same computer as the SQL Server instance.
• Only Modeler System Administrators, Modeler Database Administrators and Database Owners (dbo user) can perform this operation.
• Ensure that only Modeler database-related changes exist in the database. Any modification of user data or database schema should not be added to the database.
|
 |
Before creating a backup of a database, you must consider the following:
• Ensure no users are referenced in ownership of database objects such as, tables, roles, schemas, column keys, audit specifications, security policies.
• Ensure that all user access to the database is removed if not required.
• Ensure no user is currently working on the database.
• Ensure to clear all locks.
|
To backup a database using the ScfUtils command
ScfUtils provides a command line interface for performing Model Explorer functions.
You can back up 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 backing up a database through Model Explorer, refer to Backing up a database (Model Explorer).
Syntax:
ScfUtils -backupdb Enterprise "<database-ref>" "<backup-location>" [-T]
Where:
• <database-ref> specifies the reference to a database for backup.
Enter the database reference in the following format: \\SQL\<instance-name>\<database>
• <backup-location> specifies a backup location.
• [-T] specifies an optional parameter that truncates the database transaction log after the backup is finished.
Example:
ScfUtils -backupdb Enterprise "\\SQL\Server1@MODELER\ModelerDB" "C:\Temp" -T
|
|
Make sure the Windows account which runs the SQL Server service has access permissions to the backup destination folder.
For more information, refer to the Permissions section of the following SQL Server help topic:
BACKUP (Transact-SQL)
|