X hits on this document

423 views

0 shares

0 downloads

0 comments

78 / 200

Table 5-11

Options for restore operations (continued)

Option

Description

78

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.

Not recovered

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.

Recovered

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.

Standby

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.

Consistency Check

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.

None

Do not perform consistency checking.

Recovery

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.

Document info
Document views423
Page views423
Page last viewedSun Dec 04 09:01:28 UTC 2016
Pages200
Paragraphs4189
Words49499

Comments