How to determine if an index location is in backup mode using the SQL EnterpriseVaultDirectory database

Description

The EnterpriseVaultDirectory database IndexRootPathEntry table and view_IndexRootPath view contains information about each index location within the Directory. This includes a column named BackupMode. The BackupMode value shows the current state of each index volumne associated within the Directory.  Possible values of this entry are:

  • 0 – Indicates that the index location is NOT in backup mode. 
  • 1 – Indicates that the index location is in backup mode. While the location is in backup mode, no data will be written to the index.

Example:
Run the following SQL Query to identify all of the index locations that are currently in Backup Mode::

USE EnterpriseVaultDirectory
SELECT *
FROM View_IndexRootPath
WHERE BackupMode = 1

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)