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.