Failover with witness connectivity timing problems RRS feed

  • Question

  • SQL 2005, with an Express witness.

    The automatic failover is working correctly when I disable a network interface.  Presumably the mirror immediately contacts the witness and all it well.

    Two switches, witness available on both.  Principal and Mirror each on one of the two switches.

    If I pull the power on the principal's switch, and the mirror temporarily loses communication with the witness (I think as the switches respan) but shortly thereafter communication is restored.  The mirror can see the witness, but remains in a mirror state, never to be promoted.  Resetting the services on both mirror and witness don't seem to make it reconsider the promotion. 

    mirroring DISCONNECTED
    role MIRROR
    witness state CONNECTED

    From what I can tell, it seems like the mirror to witness connectivity test happens once, immediately upon loss of connectibity with the principal, and never again.

    Have I interpreted this correctly?  Anything I can do to change this?

    Monday, January 12, 2009 6:13 PM