January 3, 2013 at 9:20 am
Hi SQL Experts,
We have a activity coming up in our project where sql server 2005 three node cluster will be lifted and shifted to new Data center.In new DC , all IPs are getting changed which include Host IPs for each node,win cluster IP and sql network IP.
Can these IPs can be changed directly or do we need to follow any special steps.
Please suggest.
regards,
Bipan
January 4, 2013 at 6:19 am
bipan (1/3/2013)
Hi SQL Experts,We have a activity coming up in our project where sql server 2005 three node cluster will be lifted and shifted to new Data center.In new DC , all IPs are getting changed which include Host IPs for each node,win cluster IP and sql network IP.
Can these IPs can be changed directly or do we need to follow any special steps.
Please suggest.
regards,
Bipan
That is a very indept issue. Yes, it can be done as I did it about two years ago. If you do some google searches you can find how to do this. I believe though it is not recommended by Microsoft. They want you to build a new cluster and backup/restore your dbs there. I wanted to build a new cluster and do it that way but we didn't have time or money to purchase new hardware. We did it in a two stage process though. We moved it to new dc, with new IPS but on same domain then used a software tool/consultants to migrate the server to a new domain.
January 5, 2013 at 5:42 am
Are you just changing IP addresses or are you moving domains too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 5, 2013 at 7:36 am
Domain and hostname will remain same.
Please suggest.
January 5, 2013 at 11:08 am
you need to change the node IPs first so that the cluster networks are updated with the new IP\mask. Once this is done change the virtual IP for any client entry points (SQL, MSDTC, etc) including the Windows cluster IP itself.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply