How to Move or Migrate Data Store on XenApp 6 to another Server

Microsoft SQL Server 2008 R2 Express

In order to Migrate Data Store residing on Microsoft SQL Server 2008 R2 Express install Microsoft SQL 2008 Express Management Studio tool to take a backup of MF20 Database residing on Microsoft SQL Server 2008 R2 Express.

You can download X64 Bit of Microsoft SQL Server 2008 R2 Express from here
http://www.microsoft.com/express/Database/

Once you have the Management Studio Installed, Login to your Source Server and take a backup of the MF20 Database. The File Name will be MF20.Bak

Install Microsoft SQL Server 2008 R2 Express on the Host Server and install the Management Studio and Login and create a Blank Database called MF20, once you have the database created, Restore the Database which is been backed up.

Once the restoration is Successful, now we need to point the XenApp Server to New Datastore.

Stop Citrix Independent Management Architecture (IMA)Services on the XenApp Server.

On the XenApp Server Open ODBC and click on File DSN and click on ADD, Select SQL Server and click on next and click on browse and point it to the MF20.dsn residing in the IMA Folder (C:\Program Files (x86)\Citrix\Independent Management Architecture)

(See Screenshot)

Select MF20.dsn and click on Finish.

Now you need to point MF20.dsn to the New SQL Server through creating a New Data Source

(See Screenshot)

After pointing the MF20.dsn to MF20 Database on the New Server, recreate Local Host cache (LHC) on the Source Server (Please make sure you have stopped IMA Services before recreating LHC)

Now Start Citrix Independent Management Architecture (IMA) Services and open Citrix Delivery Services Consoleand verify Farm is connecting to the Datastore.

3 Comments

1. Robert says:

   2 December 2010 at 19:43

   I attempted to follow these instructions but they seem to leave out a few key items. First, you are unable to install the management studio tool on a Citrix Xenapp 6 server. It says compatibility issues exist. No biggie, I installed on the non-Citrix server I am going to be using to host the data store and connected remotely and backup the MF20 database. So the next step it to create a new database store. I’m unfamiliar with SQL and SQL express grant you but I am unable to create a new database using the Management Studio Tool. It does not see any local database instances. All services are running, etc. Is this supposed to be common knowledge? I looked up the issue and it seems I need to configure multiple pieces of SQL server to enable it to connect and create a new database. My goal is to try to make a recovery of my Xenapp 6 datastore easier and quicker. Should I just leave my datastore on the first Xenapp 6 server in the farm? What if this server fails. I have the datastore but where do I put it? I’m guessing just installing SQL on a different Citrix server will cause me the same headaches with creating a local datastore. There seems to be little to no info about Xenapp 6 available other than the basic e-docs. Frustrating.
2. admin says:

   2 December 2010 at 20:00

   Robert, please send me an email with print screen about error messages you received.
   Thanks.
   Bye
3. Matt says:

   7 January 2011 at 16:38

   Steps work great. Thanks for posting.