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
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. Veritas NetBackup™ for Enterprise Vault™ Agent Administrator's Guide
  5. Performing restores of Enterprise Vault
  7. About the Enterprise Vault Database Settings tab
Veritas NetBackup™ for Enterprise Vault™ Agent Administrator's Guide

About the Enterprise Vault Database Settings tab

On Enterprise Vault Database Settings tab you can choose how you want to leave the Enterprise Vault SQL database after a restore job completes. You have the option to leave the database operational, non-operational, or in a read-only state that enables you to still restore additional transaction logs. Also, you can perform an alternate SQL restore, a Point in time (PIT) restore, or a consistency check of the database after the restore completes.

Table: Enterprise Vault Database Setting tab options lists the restore options on the Enterprise Vault Database Setting tab.

Table: Enterprise Vault Database Setting tab options

Restore option

Description

Restore completion state

After a restore completes, you can leave an SQL database in any of the following states:

  • Operational

  • Read-only

  • Non-operational

To bring the Enterprise Vault SQL database to the required Point in time (PIT) or end-of-log (EOL), the SQL database restore consists of a set of restores. An example set of restores consists of the following:

  • A FULL database restore

  • The last CUMULATIVE (database differential) restore

  • One or more DIFFERENTIAL (transaction log) backups that were taken after the last cumulative backup

In other scenarios, the set of restores would require a subset of restores, such as a FULL or a FULL and cumulative restore. If the set contains incremental restores, the initial restores should leave the database in a "Restore pending" state so future restores append to the database. Thus, you should use the Leave database operational option only in the last restore job of the restore set. Once the database is brought online, the user cannot make any further cumulative or differential (database differential or transaction log) restores on that database. If you want to perform any further restores, you must start from a FULL database restore.

Note:

Given a PIT or EOL, the NetBackup SQL Agent has the capacity to find the SQL restore set (FULL, database differential, and transaction logs). However, the Enterprise Vault agent does not have this capability; therefore, the user must find and sequence the SQL restore set manually.

Consistency check after restore

You can check the consistency of the database after restores are complete.

To check the consistency of the database, select one of the following consistency checks when you select the Leave database operational option:

  • Full check, excluding indexes

    Select this option to 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 nonclustered index pages is not checked.

  • Full check, including indexes

    Select this option to include indexes in the consistency check. Any errors are logged. This option is selected by default.

  • Physical check only (SQL 2000 only)

    This option only applies to SQL Server 2000.

  • None

    Select this option to ensure that no consistency check occurs after a restore.

    Note:

    Any option other than None is effective only in the restore job that brings the database to an operational state.

Point-in-time recovery

To recover the Enterprise Vault SQL database to a PIT, select a restore set that includes the immediate DIFFERENTIAL (transaction log) backup after the PIT. In addition, while restoring this backup you must select the "PIT" option and specify the PIT.

You must ensure that you use the PIT option only with the last differential backup restore. You must select the Leave database operational option in the user interface to enable you to select the PIT option.

Redirected restore

Select this option and specify the new <SQL INSTANCE\SQL database name > to restore to an alternate client, alternate SQL instance, or alternate SQL database. You must do that for each restore in the restore set. The destination SQL database should not be present. If it is present, a chance of data loss in the destination database is possible.

Note:

You can change the SQL INSTANCE name, however do not change the SQL database name. If you change the SQL database name Enterprise Vault does not automatically recognize the new name. If you chose to change the SQL database name then you must also update your Enterprise Vault configuration.

Note:

A redirected restore of an auditing database must be made to the same SQL instance where the directory database resides.

Take database offline

Select this option to disconnect all the connections to the destination SQL database (including Enterprise Vault connections) before it is restored. You should use this option only with the full restore.

Feedback

Was this page helpful?
Previous

About the Enterprise Vault restore options on the General tab

Next

Specifying the server, clients, and policy type for restores

Feedback

Was this page helpful?