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

book

Article ID: 100039331

calendar_today

Updated On:

Description

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

IMPORTANT: Do not edit this content in Information Manager

Internal Notes

 

The content of this document is referenced in the Enterprise Vault 10.0 Indexing Key Topics. Do not make changes to this article. If you would like changes to be made to this content, use the Information Manager feedback feature. Alternatively, you can send e-mail to the owner or the Enterprise Vault Knowledge Management team DL-CS-KM.

Issue/Introduction

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