X hits on this document

643 views

0 shares

0 downloads

0 comments

85 / 200

To restore a filegroup

1

Browse for the backup images you wish to restore. See “Browsing for backup images” on page 80.

2

In the Restore Microsoft SQL Server Objects dialog box, expand the desired instance and database.

3

Expand the filegroup and select a filegroup image to restore. To restore a full backup, select the image of the filegroup backup.

Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface

Restoring filegroup backups

If you are periodically backing up only read-write filegroups as a part of your backup strategy. Refer to “Recovering a database from read-write backups” on page 86. For information on restoring read-only filegroups, refer to “Restoring read-only filegroups (SQL Server 2005)” on page 88.

Caution: If you attempt to restore a single differential backup without first restoring the preceding database backup file, SQL Server will halt the load process with an error such as 4305 or 4306. If you plan to restore a single differential, then you are responsible for first restoring the database backup file. You can avoid this problem by backing up the entire sequence of transaction logs, the differential backup, and the backup file to the same NetBackup Server and restoring the entire sequence of backup objects. See “Staging a full database recovery” on page 83.

85

Document info
Document views643
Page views643
Page last viewedThu Jan 19 13:47:01 UTC 2017
Pages200
Paragraphs4189
Words49499

Comments