Viewing SQL Server 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.
- Open the NetBackup MS SQL Client interface.
- Browse for the backup images that contain the read-only backup sets.
- In the Restore Microsoft SQL Server Objects dialog box, expand the instance name.
- Right-click the database and select Properties.
- 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 is found of all of the read-only filegroups, then the name appears of the latest image that contains this backup.
- If there are any read-only filegroups that are not backed up, back them up as soon as possible. These backups ensure you can perform a full recovery.
- Click OK.