To back up a database

1. Change the host and instance you want to access.

2. Select File > Backup SQL Server objects.

3. In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.

4. In the right pane, select one or more databases that you want to back up.

5. Select the Type of Backup.

   Select one of the following:

   • To perform a full backup, select Full backup.

   • To back up the database with the differential option, select Perform differential backup.

6. Select the backup options.

7. Click Backup.

8. When you are prompted to start the backup, click Yes.

9. To view the progress of the backup, select File > View status.