Home Forums SQL Server 2008 SQL Server 2008 High Availability Network Card Reset Triggers a Failover? RE: Network Card Reset Triggers a Failover?

  • December 12, 2013 at 7:35 pm

    #1673146

    Kuzey (12/12/2013)

    Hello,

    We have a two-node active/active SQL Server 2008 Std Cluster on Windows 2008 on Production.

    After a network maintenance, the network card (not heart-beat) of one node has no gateway ip. We want to fix it without causing a failover.

    I assume when we set gateway ip, the network card will be reset, and the ip will be temporarily unavailable, then fail-over happens. Am I right?

    Is there a way to play with dependencies not to initiate failover during fixing network card?

    Thanks,

    Kuzey

    Since you are not changing anything on the NIC used for the heartbeat, you should not get a failover. I would expect that the users may get a break because their connections may be severed but the failover wouldn't be initiated because the standby node can still communicate with the active node.