Procedure 5: Restoring the FSA Reporting database

Perform this procedure if you need to recover the FSA Reporting database.

Note that you will only have an FSA Reporting database if you have configured FSA Reporting.

The following procedures describe:

Restoring the FSA Reporting database to the server that previously hosted it.
Restoring the FSA Reporting 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 FSA Reporting database to the server that previously hosted it

On the SQL Server machine that used to host the FSA Reporting 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 EnterpriseVaultFSAReporting 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 FSA Reporting 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 FSA Reporting database previously existed. The 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 EnterpriseVaultFSAReporting 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 FSAReportingSettings 
SET SQLServer = 'Name of new server'
```
where Name of new server is the name of the new SQL server.