Good day All,
Welcome back!!!
I wanted to do this a quick post before i jump on playing clusters.Recently we moved Citrix database from 2 Node Window 2008 SQL 2005 cluster to Windows 2008 Standalone SQL, here are the steps we did
As this is Production Server we kind of split the cut over to 2 weekends
1st Weekend : Test Database in Xenapp 6 Farm
2nd Weekend Production Database in same Xenapp 6 Farm
Below are the steps:
First Weekend Test Database cut over:
Wintel Steps:
1. Took the IP details of Passive Node
2. Removed the Passive Node from cluster
3. UN-joined the Server from domain and Shut it down.
4.Rebuild a new VM Windows 2008 R2 and installed SQL 2005
5.Stopped all IMA Service on all Citrix Servers so that no will access database
6.Took a Full database backup
7.Restored on the new Standalone Server
8.Tested ODBC connection from Citrix data collector Server and made sure Citrix Service account is able to access the database.
Citrix Steps:
1.Backup DSN file "MF20.dsn" in Data collector
2.Stop IMA service
3.Rename existing "MF20.dsn" to "MF20_old.dsn"
4.Create a new DSN file pointing to new Standalone Server with respective database
5.Configure Datastore by running the command
dsmaint config /user:Citrix Service account /pwd:XXXX /dsn:"c:\Citrix\IndependentManagementArchitecture\MF20.dsn"
6. Recreate local host by running the command "DSmaint recreatelhc"
7.Start IMA Service
8. Run qfarm and check everything fine
9. Copy the newly created dsn file to all other citrix servers and replace the existing DSN files and rename existing one as old.
10.Stop IMA Service and run the dsmaint config as above on all the applications Servers which are accessing the test database.
11.Post checks on all Citrix Servers
Second Weekend Prod Database:
Wintel Steps:
1. Request Citrix team to stop IMA Service so that no one access the database
2.SQL team took a complete Database backup on the current Active Single Node Cluster.
3.Copied over database to Standalone Server and shutdown the Active Cluster Server
5. SQL team restored the Prod database
Citrix Steps:
Same as above on all Citrix Servers pointing to Prod Database.
After every thing was tested, we cleanup the Single Node cluster by un-join from domain and shut it down.
Special thanks to my Colleague karthik, part of Citrix team for the steps.
Hope this helps someone!!! Until next one you all have a good day!!!!
Welcome back!!!
I wanted to do this a quick post before i jump on playing clusters.Recently we moved Citrix database from 2 Node Window 2008 SQL 2005 cluster to Windows 2008 Standalone SQL, here are the steps we did
As this is Production Server we kind of split the cut over to 2 weekends
1st Weekend : Test Database in Xenapp 6 Farm
2nd Weekend Production Database in same Xenapp 6 Farm
Below are the steps:
First Weekend Test Database cut over:
Wintel Steps:
1. Took the IP details of Passive Node
2. Removed the Passive Node from cluster
3. UN-joined the Server from domain and Shut it down.
4.Rebuild a new VM Windows 2008 R2 and installed SQL 2005
5.Stopped all IMA Service on all Citrix Servers so that no will access database
6.Took a Full database backup
7.Restored on the new Standalone Server
8.Tested ODBC connection from Citrix data collector Server and made sure Citrix Service account is able to access the database.
Citrix Steps:
1.Backup DSN file "MF20.dsn" in Data collector
2.Stop IMA service
3.Rename existing "MF20.dsn" to "MF20_old.dsn"
4.Create a new DSN file pointing to new Standalone Server with respective database
5.Configure Datastore by running the command
dsmaint config /user:Citrix Service account /pwd:XXXX /dsn:"c:\Citrix\IndependentManagementArchitecture\MF20.dsn"
6. Recreate local host by running the command "DSmaint recreatelhc"
7.Start IMA Service
8. Run qfarm and check everything fine
9. Copy the newly created dsn file to all other citrix servers and replace the existing DSN files and rename existing one as old.
10.Stop IMA Service and run the dsmaint config as above on all the applications Servers which are accessing the test database.
11.Post checks on all Citrix Servers
Second Weekend Prod Database:
Wintel Steps:
1. Request Citrix team to stop IMA Service so that no one access the database
2.SQL team took a complete Database backup on the current Active Single Node Cluster.
3.Copied over database to Standalone Server and shutdown the Active Cluster Server
5. SQL team restored the Prod database
Citrix Steps:
Same as above on all Citrix Servers pointing to Prod Database.
After every thing was tested, we cleanup the Single Node cluster by un-join from domain and shut it down.
Special thanks to my Colleague karthik, part of Citrix team for the steps.
Hope this helps someone!!! Until next one you all have a good day!!!!
No comments:
Post a Comment