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 >
.
-
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
.
Select one of the following:
-
To perform a full backup of the read-write
filegroups, select .
-
To perform a differential backup of the read-write
filegroups, select .
-
Select the backup
options.
-
Click .
To view the progress of
the backup, select File > .