December 5, 2007 at 4:44 pm
Hi,
Does anyone have pointers (best practices, experience) in upgrading a Sql Server 2005 failover cluster?
We are migrating a current production failover cluster to bigger servers and we are trying to develop a strategy for this operation.
What about these ideas?
1. Build a completely new failover cluster and move the SAN LUNs over.
2. Image the current local drives on the inactive node to one of the new machines, move the fiber channel cards to the new machine and try to add back into the current cluster.
I have a strong feeling that #1 is by far the best and safest method.
Does anyone have any ideas?
Thanks,
Andy
December 5, 2007 at 6:55 pm
Andy Chamard (12/5/2007)
1. Build a completely new failover cluster and move the SAN LUNs over.
Build new one and configure it as u r expecting it to be, create all settings everything u need (login sid should be matched)....test all functionality throughly....restore ur small devp db and see everything is fine
now detach orig cluster db and attach it to new one.....ip changes and all that is as expected....
Prakash Heda
Lead DBA Team - www.sqlfeatures.com
Video sessions on Performance Tuning and SQL 2012 HA
December 6, 2007 at 9:02 am
Hi Prakash,
Thanks for the info. I think we are going to go with #1. Build a new cluster, migrate the logins, move the LUNs and the attach the dbs.
Thanks,
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply