Options for restore operations (continued)
Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface
Create partial database restore template
(SQL Server 2000 only) Create a template for a partial database restore.
Restore read-only filegroups
(SQL Server 2005 only) Restore the most recent backup of every read-only filegroup.
Create a page restore template
(SQL Server 2005 only) Create a template for restoring a database, filegroup, or file from the pages contained in the selected backup image.
Verify backup image, but don't restore
(SQL Server 2005 only) This option is only available if the image was backed up using the page verification option. NetBackup will process the image for errors, but will not perform a restore.
Use this option during a restore if additional backup images must be applied to the database following the current restore. When you use this option, the database is left in a loading state.
Select this option when restoring the last image in a restore sequence. After the recovery operation, the database is ready for use. If recover database is not performed, the database is in an intermediate state and is not usable. If Recovered is selected when an intermediate backup is being applied, you cannot continue to restore backups; you must restart the restore operation from the beginning.
Create and maintain a standby during a transaction log and database restore. This option requires a standby undo log, which, by default, is placed in install_path\NetBackup\logs\SQLStandBy\. The database is placed in “standby” state following the restore.
Select the consistency check to be performed after the restore. Output from the consistency check is written to the SQL Server client progress log. You cannot select consistency checking unless the database is being restored to the recovered state. If you choose consistency checking for a staged recovery, then the check occurs following the last restore.
Do not perform consistency checking.
Specify one of the SQL Server recovery options.
Full check, excluding indexes
Exclude indexes from the consistency check. If indexes are not checked, the consistency check runs significantly faster but is not as thorough. Only the data pages and clustered index pages for each user table are included in the consistency check. The consistency of the non-clustered index pages are not checked.
Full check, including indexes
Include indexes in the consistency check. Any errors are logged.