Procedure 4: Restoring the Monitoring database

Perform this procedure if you need to recover the Monitoring database.

The following procedures describe:

Restoring the Monitoring database to the server that previously hosted it.
Restoring the Monitoring database to a different SQL server machine. You can use this procedure if the original machine is unavailable, for example if you cannot recover it.

To restore the Monitoring database to the server that previously hosted it

On the SQL Server machine that used to host the Monitoring database, start SQL Enterprise Manager by clicking Start > Programs > Microsoft SQL Server Enterprise Manager.
Expand the view until you see the Databases container, and then select it.
On the Tools menu, click Restore Database.
In the Restore database dialog box, select EnterpriseVaultMonitoring in the Restore as database box.
Next to Restore, click From device, and then click Select Devices. The Choose Restore Devices dialog box appears.
Click Add.
In the Choose Restore Destination dialog box, select the backup file from which to restore, and then click OK.
Click OK to close the Choose Restore Destination dialog box, and then click OK again to close the Choose Restore Devices dialog box.
In the Restore database dialog box, ensure that the options Restore backup set and Database - complete are selected.
Select the Options tab, and then select Leave database operational. No additional transaction logs can be restored.
Click OK to start the restoration.

To restore the Monitoring database to a different SQL server machine

Ensure the new SQL server machine contains the same folder structure on the same drive as the original SQL server machine where the Monitoring database previously existed. The Monitoring database must be restored to the same location on the new machine that it occupied on the original machine.
On the new SQL Server machine, start SQL Enterprise Manager by clicking Start > Programs > Microsoft SQL Server Enterprise Manager.
Expand the view until you see the Databases container, and then select it.
On the Tools menu, click Restore Database.
In the Restore database dialog box, enter EnterpriseVaultMonitoring in the Restore as database box.
Next to Restore, click From device, and then click Select Devices. The Choose Restore Devices dialog box appears.
Click Add.
In the Choose Restore Destination dialog box, select the backup file from which to restore, and then click OK.
Click OK to close the Choose Restore Destination dialog box, and then click OK again to close the Choose Restore Devices dialog box.
In the Restore database dialog box, ensure that the options Restore backup set and Database - complete are selected.
Select the Options tab, and then select Leave database operational. No additional transaction logs can be restored.
Click OK to start the restoration.
When the restoration has completed, click OK to close the success message.
Connect to the SQL server using SQL Enterprise Manager or SQL Query Analyzer, or a similar tool.
Enter and run the following SQL commands:
```
USE EnterpriseVaultDirectory
UPDATE MonitoringSettings 
SET SQLServer = 'Name of new server'
```
where Name of new server is the name of the new SQL server.