Backing up database files

This procedure describes how to back up database files.

To back up a database file

  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, expand the instance name and database.

  4. In the left pane, select the filegroup that contains the files you want to back up.

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

  6. Select the backup options.

  7. Click Backup.

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

More Information

Selecting the SQL host and instance

Backup Microsoft SQL Server Objects field descriptions