I'm running a Xenapp 5.0 farm and we are decomming the SQL 2005 server that houses our Data Store. Does anyone know the easiest way to move the Data Store from one SQL server to another? Does this require an outage? I have read that it can be done online as long as the Xenapp servers can contact the licensing server. Any help would be appreciated, thanks.
1. Take a backup of your exisiting datastore.
2. Restore the copy of your backup to new SQL server.
3. On every server create a new file dsn pointing to the new SQL server.
4. Run dsmaint config command pointing to the newly created dsn.
5. restart IMA services, if they fail to start back up try dsmaint recreatelhc and try again.
These are the basic steps, I don't think I have missed anything out.
After you try the first server you can run discovery and try to publish a app and you will know it has worked.
Citrix Customer Advisory Community
Good instructions. I'm curious, do i need an outage for this or can i do it during production? Also i'm apprehensive about the dsmaint config command. Is the user name referrenced in DSMaint the SQL account that we used?
I have done this recently and I used the following script. I manually run the script on each server with the pause commands so that I can verify that they are sucessful. Before I start each server I modify the dsn file on the network share so that I have the right WSID value. It does require that the IMA be stopped so I always do it during an outage window.
Jim
xcopy "\\server\data\technology\applications\citrix\dsn file\MF20.dsn" "C:\Program Files\Citrix\Independent Management Architecture" /y
pause
net stop imaservice /y
dsmaint config /user:username /pwd:password /dsn:"C:\Program Files\Citrix\Independent Management Architecture\MF20.dsn"
dsmaint recreatelhc
rem Will Fail for MF XP Servernet start "Citrix SMA Service"
rem Will Fail if MPS3.0 or CPS4.0 as command above already started servicenet start imaservices
If you are creating and copying new dsn file at programfiles\citrix\independent management architecture.
you need to change the target location in registry also , hklm\software\citrix\ima - right pane change the data source name target location to new dsn name.
stop citrix ima service , copy new dsn file , change registry value, start the ima service . these steps should do it.
do we need to recreate lhc and run dsmaint commands?
You would only need to change the registry value if you changed the actual name of the dsn file correct? Or am I missing something? All you want to do is modify the server value in the dsn file. The file name shouldn't need to change.
It all sounds relatively straight forward. I'm still unsure of the credentials used in the DSMaint command. Are these the creds of a Citrix Admin or the SQL account we used for this DB?
@ Jim ...
yes you need the change in registry only if you change the actual name of the dsn file .
the reason why we create new dsn file is . if anything goes wrong , we can make the registry change to point to old dsn file and restart the ima. kind of backup plan
if you edit the existing dsn file then we don't need changes in registry.
Yeah it is quick and easy. Don't stress it. The dsmaint credentials are the SQL db account info. Not he Citrix admin info.
Ok I am following you now VenKat. Yeah that makes sense and would be an easy backout.
After I stop the IMA service, can I just use notepad to edit the MF20.dsn?
Yes you can use notepad.