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.

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.

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)