Restoring read-only filegroups (SQL Server 2005 or later)

This topic describes how restore read-only filegroups. This type of restore operation only applies to SQL Server 2005 or later.

To restore read-only filegroups

  1. Browse for the backup images you want to restore.

    Be sure that the start date for the Time Filter is early enough to include the timestamp of the earliest backup of the read-only filegroups.

  2. In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.

  3. Select the database that contains the read-only filegroups you want to restore.

    In the Scripting list, Restore read-only filegroups is selected.

    The restore option is enabled if a full set of read-only filegroups is available.

  4. Click Restore.

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

More Information

Restoring filegroup backups

Recovering a database from read-write backups

Browsing for backup images