Backing up a database (Model Manager)
 |
• 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 in Model Manager
1. Right-click the database you want to back up, and select Perform Task.. and then click Backup.
2. From the Task list, select Backup.
3. To start the backup immediately, select Now, and then click START.
To schedule the backup for a later date or time, select Later, select the Start Date and Start Time, and then click Schedule.
4. On the Truncate Log After Backup dialog, click Yes if you want to truncate the SQL Database log after backup, else click No.
5. After the backup is complete, the Executed Tasks section is updated with the backup details. You can click the 
button to download the .bak file to your computer.
button to download the .bak file to your computer.