Disaster recovery and creation of a new Sync History database (4336722)

Disaster recovery and creation of a new Sync History database

A scenario might arise where the existing Quick Connect or Active Roles Synchronization Service Synchronization History database (also known as the Execution database) cannot be used for some reason: this may be due to data consistency issues, exceptional data bloat, etc.

It might be necessary for the stability or usability of the solution to archive the existing Synchronization History database and start fresh with a new one. This can be done without reinstalling the product and with minimal downtime.

1. In the top right of the Quick Connect Console, click on the Gear icon.
2. Click "Export Configuration" | "Browse" and save the current configuration.
3. Click on the Gear icon again and then click "Configure Sync Engine...".
4. Choose "Create a new configuration" | "Next"
5. Specify the SQL Server and a new SQL database name.
6. Check the box labeled "Store sync data in a separate database" and specify the new Synchronization database name.
7. Specify an account with the permissions necessary to create databases on the target SQL server and click "Next".
8. Save the new configuration profile file under a different file name and click "Finish"
9. Close the Quick Connect Console, restart the Quick Connect service, and reopen the console.
10. Click on the Gear icon and then click "Import Configuration..."
11. Select the relevant Quick Connect version and DO NOT check the box labeled "Import sync history"
12. Click "Next" | "Browse" and select the configuration file created in Step 2 above.
13. Click "Next" | "Start Import" | "Finish"
14. Close the Quick Connect Console, restart the Quick Connect service, and reopen the console.
15. Confirm functionality by running a test Workflow.