Backing up a database (Model Explorer)
 |
• 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 Explorer
1. Start Model Explorer.
2. Locate the database that you want to back up:
a. Expand the SQL icon.
b. Expand the Server that owns the database you want to back up.
If the Server that owns the Database is not shown, add the Server to Model Explorer.
For more information, refer to Adding a server to Model Explorer.
c. If the Database you want to back up is not shown, show the server's databases and optionally bookmark the Database you want to back up.
For more information, refer to Showing a servers database.
3. Right-click the database you want to back up, point to Backup, then select one of the following options:
◦ Backup...—to create a backup.
◦ Backup and Truncate Log...—to create a backup and truncate the database transaction log file.
4. In the Select backup location dialog box, specify a folder and click OK.
5. Confirm that the Database BackedUp Successfully message appears, then click OK.
|
|
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): https://docs.microsoft.com/sql/t-sql/statements/backup-transact-sql?view=sql-server-2014
|