 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Clustering / September 2006Move 2005 cluster to new hw
I will have to move a 2-node SQL2005 MSCS cluster to new servers. Wonder if I could just - remove node1 from cluster - add node3 to cluster - remove node2 from cluster - add node4 to cluster Is this a valid plan? Ole Thomsen Yes. But it is a bit more complex. Uninstall SQL from Node1. Evict Node1 from the cluster. Add Node3 to the cluster Install SQL to node 3 Test, Test, Test Uninstall SQL from Node2. Evict Node2 from the cluster. Add Node4 to the cluster Install SQL to Node 4 Test, Test, Test again. I have done this process using SQL 2000 and it works. I haven't tested it with SQL 2005, but the basic steps should not have changed.  SignatureGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP >I will have to move a 2-node SQL2005 MSCS cluster to new servers. > [quoted text clipped - 8 lines] > > Ole Thomsen This is very useful information, thanks. Ole Thomsen > Yes. But it is a bit more complex. > [quoted text clipped - 24 lines] >> >> Ole Thomsen I discovered the hard way that SQL uninstall in 2005 means uninstall BOTH nodes (just like install is on both) :-) Otherwise the swap went fine, just a bit more downtime than expected and a restore of system databases at the end. Ole Thomsen > Yes. But it is a bit more complex. > [quoted text clipped - 24 lines] >> >> Ole Thomsen If your disks are on SAN, you can also just create a new and separate cluster, install SQL Server exactly the same as the old cluster, remove the shared drives from the old cluster, remove the shared drives from the new cluster, and present the drives from the old cluster to the new cluster, making sure the drive letters are assigned the same. If you can afford the down time during the switch, this gives you an alternative approach. Another problem of this approach is that you'll end up with new IP addresses and new network names. Linchi > I will have to move a 2-node SQL2005 MSCS cluster to new servers. > [quoted text clipped - 8 lines] > > Ole Thomsen Well, the change had to be transparent to users and network, so I chose the "rolling swap". Thanks, Ole Thomsen > If your disks are on SAN, you can also just create a new and separate > cluster, install SQL Server exactly the same as the old cluster, remove [quoted text clipped - 22 lines] >> >> Ole Thomsen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.