Options for SQL Server restores
The following options exist when you perform restores of SQL Server.
Table: Recovery options
Option | Description |
|---|
|
NetBackup processes the image for errors, but does not perform a restore. This option does not apply to snapshot images. |
|
|
Select the state for the database after the restore. Restore the last image in a restore sequence and make the database ready for use. Restore an intermediate backup image. The database is left in a loading state so you can restore and apply additional backup images. 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 the same directory as the primary datafile. The account that runs the SQL Server service must have full access
permission to the SQLStandBy folder.
|
|
| The consistency check to perform after the restore. Output from the consistency check is written to the SQL Server client progress log. Do not perform a consistency check. Include indexes in the consistency check. Any errors are logged. 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 is not checked. Check for consistency in and between system tables in the specified database. Perform a low overhead check of the physical consistency of the SQL Server database. This option only verifies the integrity of the physical structure of the page and the record headers. It also verifies the consistency between the pages' object ID and index ID and the allocation structures.
|
|
| This option allows SQL Server to overwrite a database or any database files, if they already exist. If this operation is not available, contact your NetBackup administrator for the necessary RBAC permission. Disconnects any active users before the restore operation runs. |
| Determines the time out interval for SQL Server Virtual Device Interface. The selected interval is applied to backups and restores of databases and of transaction logs.
The default value for backups is 300. The default value for restore operations is 600. Range is 300 - 2147483647. |
