Re: IP Restructuring for SQL Server Cluster

The key to changing IP addresses on a cluster is to make sure the cluster
always has a valid communication path between all nodes. This is the
primary reason that clustering best practices requires a minimum of two
separate network ports on each host node. Change one network and get it
working correctly, then change the other network.

Also, some SANs use out-of-band communications to their host nodes or even
to itself. Changing IPs may affect this ability. Usually, that only
affects management functions, the SAN will typically keep operating.

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP





"bass_player" <bassplayer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1957A8ED-104C-4346-9707-FC355F591615@xxxxxxxxxxxxxxxx
We are planning to have our IPs restructured on our disaster recovery site
(DR) because of some business policies and requirements. We are running
an
active-passive SQL Server 2000 Cluster environment on both sites. I am
running log shipping on this particular environment. Is there anything I
need to prepare before we do the IP restructuring fr the entire
environment -
Windows, SQL Server, etc.? Any tips will be greatly appreciated
--
MCP MCDBA MCAD MCSD MCT MCTS:SQL Server 2005
"Helping people grow and develop their full potential as God has plan for
them"


.

Relevant Pages

  • Re: Why Cluster in a test Environment?
    ... If your apps are not failover aware, ... SQL Server 2000 then takes anywhere from 30 seconds to minutes before ... a cluster but not appear in a standalone server. ... A non-clustered environment would not allow accurate stress testing do ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
Loading