X hits on this document

490 views

0 shares

0 downloads

0 comments

79 / 200

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

Table 5-11

Options for restore operations (continued)

Option

Description

Check catalog

Check for consistency in and between system tables in the specified database.

Physical check only

(SQL Server 2000 or later) Select this to perform a low overhead check of the physical consistency of the SQL Server 2000 or later database. This option only checks the integrity of the physical structure of the page and record headers, and the consistency between the pages’ object ID and index ID and the allocation structures.

Page verification

(SQL Server 2005 only) These options are available if the source object was backed up with torn page detection or checksum verification.

Note: There is a performance penalty when using page verification.

Do not perform verification

Do not include page verification in the restore script.

Perform verification

Include page verification in the restore script and stop the restore if an error is encountered.

Transaction logs

This group contains transaction log recovery options. It is enabled if you select a transaction log backup image.

Stage full recovery

Select this option if you wish to recover the database using the recovery set that NetBackup has found. If the transaction log that you have selected does not belong to a recovery set, then this option is disabled.

Restore selected transaction log

Select this option to restore only the highlighted transaction log. If the transaction log that you have selected does not belong to a recovery set, then this option is disabled.

Transaction log recovery options

This list contains the controls for you to restore a transaction log to a point in time that precedes the time at which the transaction log was dumped. The individual entries in this group are only enabled if you have highlighted a transaction log backup.

For SQL Server 7.0, the only available option from this group is To point in time. The remaining options, which allow you to restore to a transaction mark, or to a time before or after a transaction mark, are enabled if you have a later version of SQL Server.

To point in time

Select this radio item to have the transaction log recovered to a point in time.

To transaction log mark

Select this radio item to have the transaction log recovered to a transaction log mark. With this option, you must enter a transaction log mark name.

To transaction log mark but after

Select this radio item to choose to have the transaction log recovered to a transaction log mark but after a point in time. With this option, you must enter a transaction log mark name.

79

Document info
Document views490
Page views490
Page last viewedWed Dec 07 16:39:52 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments