Options for SQL Server restores — NetBackup 11.2 | Cohesity Documentation

Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist

Options for SQL Server restores — NetBackup 11.2 | Cohesity Documentation

NetBackup™ for Microsoft SQL Server Administrator's Guide

Options for SQL Server restores

The following options exist when you perform restores of SQL Server.

Table: Recovery options

Option	Description
Verify backup image but do not restore	NetBackup processes the image for errors, but does not perform a restore. This option does not apply to snapshot images.
Database recovery state after restore	Select the state for the database after the restore. Recover Restore the last image in a restore sequence and make the database ready for use. Restoring Restore an intermediate backup image. The database is left in a loading state so you can restore and apply additional backup images. 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 the same directory as the primary datafile. The account that runs the SQL Server service must have full access permission to the `SQLStandBy` folder.
Consistency check	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 Do not perform a consistency check. Full check, including indexes Include indexes in the consistency check. Any errors are logged. 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 is not checked. Check catalog Check for consistency in and between system tables in the specified database. Physical check only 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.
Overwrite the existing database	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. Disconnect users Disconnects any active users before the restore operation runs.
VDI timeout	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.

Feedback

Was this page helpful?

Feedback

Was this page helpful?