X hits on this document

392 views

0 shares

0 downloads

0 comments

71 / 200

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

1

Browse for the backup images containing the read-only backup sets. See “Browsing for backup images” on page 80.

2

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

3 4

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.

71

Document info
Document views392
Page views392
Page last viewedSat Oct 29 00:27:32 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments