SQL 2005 3 node cluster lift and shift with IP change

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » SQL 2005 3 node cluster lift and shift with...

SQL 2005 3 node cluster lift and shift with IP change

Rate Topic

Display Mode

Topic Options

Author

Message

bipan

Posted Thursday, January 03, 2013 9:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, January 05, 2013 7:34 AM
Points: 48, Visits: 375

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

Post #1402440

Markus

Posted Friday, January 04, 2013 6:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 1,048, Visits: 2,217

bipan (1/3/2013)

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.

Post #1402840

Perry Whittle

Posted Saturday, January 05, 2013 5:42 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204, Visits: 11,165

Are you just changing IP addresses or are you moving domains too?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" Wink

Post #1403223

bipan

Posted Saturday, January 05, 2013 7:36 AM

SSC Rookie

Group: General Forum Members
Last Login: Saturday, January 05, 2013 7:34 AM
Points: 48, Visits: 375

Domain and hostname will remain same.
Please suggest.

Post #1403230

Perry Whittle

Posted Saturday, January 05, 2013 11:08 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:44 AM
Points: 5,204, Visits: 11,165

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" Wink

Post #1403262

« Prev Topic | Next Topic »

Permissions