Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Friday, May 6, 2016 7:43 PM
Points: 57, Visits: 444
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


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 23, 2016 6:22 AM
Points: 1,498, Visits: 3,517
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, May 17, 2016 7:44 AM
Points: 8,111, Visits: 16,284
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: Friday, May 6, 2016 7:43 PM
Points: 57, Visits: 444
Domain and hostname will remain same.
Please suggest.
Post #1403230
Posted Saturday, January 5, 2013 11:08 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Tuesday, May 17, 2016 7:44 AM
Points: 8,111, Visits: 16,284
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