Restoring and Deleting Databases

Restoring Survey Databases

If a Forsta Plus database is restored from backup, service broker must be set manually for the database so that Forsta Plus will function correctly. Also, the ConfirmitDeploy SQL user should be set as the owner of the database. Run the following command after restoring a survey database to enable the broker on the database:

ALTER DATABASE YourDatabase SET NEW_BROKER WITH ROLLBACK IMMEDIATE

ALTER AUTHORIZATION ON DATABASE::YourDatabase TO [ConfirmitDeploy]

Note: Ensure that the ConfirmitDeployer SQL account is the database owner after restore. The current user will always take ownership when restoring databases.

Deleting Survey Test Databases

Administrators may also notice that survey test databases expand over time, and after a while can take up quite a lot of space on the server. To keep the number of test databases to a minimum, a maintenance job can be added on the database server to delete databases that have been inactive for a specified period. An example script to add as a procedure for automating this job is available by contacting [e-mail].