Backing up database filegroups

More information is available on how to use read-write and read-only filegroups in your backup strategy.

To back up a database filegroup

  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.

  4. Select a database whose filegroups you want to back up.

  5. In the right pane, select one or more filegroups 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

Backing up read-write filegroups (SQL Server 2005 or later)

Selecting the SQL host and instance

Backup Microsoft SQL Server Objects field descriptions