Viewing read-only backup sets

If you perform periodic backups only on read-write filegroups, you can verify if you have retained backups of the read-only filegroups.

To view read-only backup sets

  1. Browse for the backup images that contain the read-only backup sets.

  2. In the Restore Microsoft SQL Server Objects dialog box, in the left pane, expand the instance name.

  3. In the right pane, right-click the database and select Properties.

  4. Click the "Read-only backup set" tab.

    If the database does not contain read-only filegroups, then the message "This database does not contain any read-only filegroups." is shown. If backups do not exist for all of the read-only filegroups, then a list of the filegroups that were not backed up is shown. Finally, if a backup of all of the read-only filegroups is found, then the name appears of the latest image that contains this backup.

  5. If there are any read-only filegroups that are not backed up, back them up as soon as possible. Do this to ensure you can perform a full recovery.

  6. Click OK.

More Information

Browsing for backup images