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

This procedure describes how to back up read-write filegroups. This type of backup can only be performed with SQL Server 2005 or later.

Note:

Backups of read-write filegroups are not supported if you have SQL Express. SQL Server Express Edition has limited support for recovering from this backup type.

To back up read-write filegroups

Change the host and instance you want to access.
Select File > Backup SQL Server objects.
In the Backup Microsoft SQL Server Objects dialog box, in the left pane, select the database instance.
In the right pane, select one or more databases that you want to back up.
Select the Type of Backup.
Select one of the following:
- To perform a full backup of the read-write filegroups, select Read/write filegroups.
- To perform a differential backup of the read-write filegroups, select Differential on read/write filegroups.
Select the backup options.
Click Backup.

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