Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface
Backing up read-only filegroups (SQL Server 2005)
In order to back up read-only filegroups you must first create a separate policy for this type of backup. Refer to “Reducing backup size and time by using read-only filegroups (SQL Server 2005)” on page 54. You can verify that all read-only filegroups are backed up. Refer to “Viewing read-only backup sets.”
Viewing read-only backup sets
If you have made a decision to do periodic backups only on read-write filegroups, you will want to know whether you are currently retaining backups of the read-only filegroups.
To view read-only backup sets
Browse for the backup images containing the read-only backup sets. See “Browsing for backup images” on page 80.
In the Restore Microsoft SQL Server Objects dialog box, in the left pane, expand the instance name.
In the right pane, right-click on the database and choose 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 of all of the read-only filegroups is found, then the name of the latest image containing this backup is displayed.
The following image shows an example of a complete recovery set based on several read-only filegroups images.