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

Article:HOWTO56256  |  Created: 2011-07-27  |  Updated: 2014-12-10  |  Article URL http://www.symantec.com/docs/HOWTO56256
Article Type
How To



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




Article URL http://www.symantec.com/docs/HOWTO56256


Terms of use for this information are found in Legal Notices