Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 3 node cluster lift and shift with IP change Expand / Collapse
Author
Message
Posted Thursday, January 3, 2013 9:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 2:20 PM
Points: 52, Visits: 401
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
Posted Friday, January 4, 2013 6:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:42 AM
Points: 1,242, Visits: 2,743
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.



Post #1402840
Posted Saturday, January 5, 2013 5:42 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:53 PM
Points: 6,192, Visits: 13,341
Are you just changing IP addresses or are you moving domains too?

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1403223
Posted Saturday, January 5, 2013 7:36 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: 2 days ago @ 2:20 PM
Points: 52, Visits: 401
Domain and hostname will remain same.
Please suggest.
Post #1403230
Posted Saturday, January 5, 2013 11:08 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:53 PM
Points: 6,192, Visits: 13,341
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"
Post #1403262
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse