Moving Appsense SQL Database

I have a unofficial Appsense Guide to moving the Appsense SQL Server database.
The task basically involves these steps

Use SQL Management Server to detach database
Move the database
Use SQL Management Server to attach database
Adjust security and roles on new database
Uninstall Appsense Management Server
Install Appsense Management server pointing at new SQL Server
Install Appsense Consoles as required

PDF document attatched with full guide and screenshots

Appsense%20Database%20Move.pdf

I performed the Move successfully at client site, with these instructions.
I also moved the Appsense Management Server to another server.
To perform this i did the following.

I added the new server to the failover list in the appsense management console.
I checked this Failover URL went out to my farm.
I then installed the Appsense Management server software on my new server.
I then stopped IIS on the old Management server
I then checked eventlog on Terminal servers to make sure they started to talk to the failover server
I then shutdown the old Appsense Management Server
The Agents seemed to have now set themselves to talk to the new server. The CCA registry key point to new server. (I thought i would have had to manually correct this key?)


NOTE : We did have a DNS Alias setup for the Appsense Management server but this turns out to be of little use as the agents still seem to store the actual server name even though the MSI push install of the Agent specified the DNS Alias. Possibly the DNS alias works when the agent is deployed with the CCA deployment tool ?