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
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.
To view the progress of the restore, select File > View status.
More Information