Return
-
Title
How to move the Change Auditor database to a new SQL server -
Description
What are the steps to move the Change Auditor database to a new SQL server? -
Cause
N/A -
Resolution
- On all Coordinator servers, right click the Coordinator System Tray icon and select Disable Coordinator
- Using SQL Server Management Studio, connect to the SQL server, right click the CA database and select Properties
- Select Options and note the Collation
- Using SQL Server Management Studio backup the CA database and restore it to the new SQL server (or copy/move the MDF and LDF files to the new SQL server and then attach them). Try to ensure the Collation of the DB on the new server is the same as what it was on the old server. It is a good idea to leave the CA database on the old SQL server offline, just in case you forget to update one of the coordinators.
- On the Coordinator servers, right click the System Tray icon and select Coordinator Configuration
- On the Security tab update the SQL server name to the new server
- Right click the System Tray icon again and select Enable Coordinator
Note: If the Collation on the database changes, the coordinator will not be able to connect to the DB and will not start. If this happens, please see the following KB Article:https://support.quest.com/change-auditor/kb/215378/after-moving-the-change-auditor-database-to-a-new-sql-server-the-coordinator-starts-stops-with-the-error-database-collation-differs-from-server-collation-215378-