Recovery procedure 2: Restoring Enterprise Vault databases

Article:HOWTO56554  |  Created: 2011-08-01  |  Updated: 2013-07-12  |  Article URL http://www.symantec.com/docs/HOWTO56554
Article Type
How To


Subject


Recovery procedure 2: Restoring Enterprise Vault databases

Restore the following Enterprise Vault SQL databases:

  • EnterpriseVaultDirectory

  • EnterpriseVaultMonitoring

  • EnterpriseVaultAudit

  • Each FSA Reporting database you have set up, if you use FSA Reporting.

  • Fingerprint databases

  • Vault store databases

If you have restored EnterpriseVaultMonitoring or the FSA Reporting databases to a SQL server other than the one that previously hosted them, you must update the Directory database.

To update the monitoring settings in the Directory database

  • On the SQL server that hosts the Directory database, run the following SQL script:

    USE EnterpriseVaultDirectory
    UPDATE MonitoringSettings 
    SET SQLServer = 'SQL_server_name'

    where SQL_server_name is the name of the new SQL server.

To update the FSA reporting settings in the Directory database

  1. On the SQL server that hosts the Directory database, run the following SQL script to determine which SQL server hosted each FSA Reporting database:

    USE EnterpriseVaultDirectory
    Select SQLServer,DatabaseName From FSAReportingDatabase
  2. Run the following SQL script:

    USE EnterpriseVaultDirectory
    UPDATE FSAReportingDatabase 
    SET SQLServer = 'SQL_server_name'
    WHERE DatabaseName = 'FSA_reporting_database_name'

    where:

    • SQL_server_name is the name of the new SQL server.

    • FSA_reporting_database_name is the name of the FSA Reporting database that you restored.

See About using EVSVR as part of the recovery procedure


Legacy ID



id-SF650195823_v41328148


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


Terms of use for this information are found in Legal Notices