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|
Restore the following Enterprise Vault SQL databases:
Each FSA Reporting database you have set up, if you use FSA Reporting.
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
To update the FSA reporting settings in the Directory database
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
Run the following SQL script:
USE EnterpriseVaultDirectory UPDATE FSAReportingDatabase SET SQLServer = 'SQL_server_name' WHERE DatabaseName = 'FSA_reporting_database_name'
Article URL http://www.symantec.com/docs/HOWTO56554