Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface
Options for restore operations (continued)
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.
(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.
Include page verification in the restore script and stop the restore if an error is encountered.
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.