Recovering Venafi database for Microsoft SQL

Applies to versions:

15.3+

Recovery Steps:

When recovering Venafi database there are a few steps required. 

1.  Recover database from file or preferred application. 
2.  Restart Service broker for Database

Example file recovery:

1. Shutdown all Venafi services on all servers
2. Open MSSQL Management Studio
3. Select New Query

4. ALTER DATABASE Director SET SINGLE_USER

   RESTORE DATABASE Director

   FROM DISK = '.bak file location'

   with replace

   ALTER DATABASE Director SET MULTI_USER

   ALTER DATABASE Director SET ENABLE_BROKER

5. Finally restart Venafi services on all servers. 

Common Errors:

After recovery it is common for logging and notifications to not work. This is due to Service Broker not having been restarted. You can check if service broker is enabled by running the following query.

SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database_name';

If it is enabled you should see a 1 under the "is_broker_enabled" column.

If it is set to "0" then stop all Venafi services again and run the following command.

ALTER DATABASE Director SET ENABLE_BROKER

If you have migrated your database and have tried all steps above and it is still not working. Please reach out to CS to have them fix the Service Broker.