Restoring SQL Server read-only filegroups
This topic describes how to restore read-only filegroups.
To restore read-only filegroups
- 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.
- In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.
- 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.
- Click Restore.
- To view the progress of the restore, select File > View status.