Tuesday, March 20, 2012

re IP servers in a cluster and cluster resources

I have a three node cluster that I have to move to a different subnet. Here
is my plan
1) fail all resources over to third node in cluster
2) change IP's of the physical nics in the two nodes without resources
3) run SQL server setup on the third node to change the cluster IP and the
virtual SQL server IP to the new subnet
4) move cluster over to the nodes that I have already changed the IP's of.
5) change the physical nics IP on the third node to the new subnet.
Does this sound like a resonable plan or do you have any suggestions?
How about instructions from Microsoft:
How to change the network IP addresses of SQL Server virtual servers
http://support.microsoft.com/kb/244980/en-us
Also, make sure you don't lose connectivity with your SAN if it uses
out-of-band IP communication. It shouldn't affect the actual operation, but
it can make maintenance difficult.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"RG" <RG@.discussions.microsoft.com> wrote in message
news:088C254A-B229-4912-9354-57CB6665995E@.microsoft.com...
>I have a three node cluster that I have to move to a different subnet.
>Here
> is my plan
> 1) fail all resources over to third node in cluster
> 2) change IP's of the physical nics in the two nodes without resources
> 3) run SQL server setup on the third node to change the cluster IP and the
> virtual SQL server IP to the new subnet
> 4) move cluster over to the nodes that I have already changed the IP's of.
> 5) change the physical nics IP on the third node to the new subnet.
> Does this sound like a resonable plan or do you have any suggestions?
|||I saw that article, but that only explains changing the IP of the virtual sql
server. That doesn't explain what should be done first or how chaning the
IP's on the machines with a cluster should go. That is why I was wondering
what I should do first?
"Geoff N. Hiten" wrote:

> How about instructions from Microsoft:
> How to change the network IP addresses of SQL Server virtual servers
> http://support.microsoft.com/kb/244980/en-us
> Also, make sure you don't lose connectivity with your SAN if it uses
> out-of-band IP communication. It shouldn't affect the actual operation, but
> it can make maintenance difficult.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "RG" <RG@.discussions.microsoft.com> wrote in message
> news:088C254A-B229-4912-9354-57CB6665995E@.microsoft.com...
>
>
|||You have to change the machine's IP Addr first, then follow the Q.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"RG" <RG@.discussions.microsoft.com> wrote in message
news:C7D1E071-473D-46FC-AFFD-C7800B6D0CB3@.microsoft.com...[vbcol=seagreen]
>I saw that article, but that only explains changing the IP of the virtual
>sql
> server. That doesn't explain what should be done first or how chaning the
> IP's on the machines with a cluster should go. That is why I was
> wondering
> what I should do first?
> "Geoff N. Hiten" wrote:
|||The key to the whole thing is to make sure the cluster services on each host
node always have a working communications path. If you have that,
everything else is fixable.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"RG" <RG@.discussions.microsoft.com> wrote in message
news:C7D1E071-473D-46FC-AFFD-C7800B6D0CB3@.microsoft.com...[vbcol=seagreen]
>I saw that article, but that only explains changing the IP of the virtual
>sql
> server. That doesn't explain what should be done first or how chaning the
> IP's on the machines with a cluster should go. That is why I was
> wondering
> what I should do first?
> "Geoff N. Hiten" wrote:

No comments:

Post a Comment