Citrix Xen Application DataStore Move

To move SQL database from the old server to the new server:

• Stop IMA service on all Citrix servers
• Take a full backup of the data store DB from the old server
• Restore the backup to the new SQL server
• Edit the MF20.DSN ODBC file on Zone data collector server
• Change the old server to the new server
• Run the following command

C:> dsmaint config /user:sql-username /pwd:sql-password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\MF20.dsn"

C:> dsmaint recreatelhc

• Start the IMA service
• Do the same thing for the rest of the servers