Moving the Monitoring database

You can move the Monitoring database between SQL Server instances. This is useful for reconfiguration and disaster recovery.

To move the Monitoring database

  1. Move the EnterpriseVaultMonitoring database to the new SQL Server.

  2. Ensure that the Vault Service account has the required permissions to access the new database.

  3. Ensure that the new SQL Server is running.

  4. Connect to the SQL server that is hosting the EnterpriseVaultMonitoring database, using SQL Enterprise Manager or SQL Query Analyzer, or a similar tool.

  5. Enter and run the following SQL commands:

    USE EnterpriseVaultDirectory
UPDATE MonitoringSettings SET SQLServer = 
"New_SQL_Server"

    where New_SQL_Server is the name of the new SQL server.