none
Question on sql cluster failover behaviour RRS feed

  • Question

  • Hi Experts,

    I have a doubt on SQL Cluster.

    In SQL cluster, If we MOVE the group or failover the group to another node what happens to the user connections(say 100 conn's) and ongoing open transactions during failover?
    Will all connections gets disconnected and open transactions gets rollbacked or the connections and txns will be moved to other node?

    Could anyone shed some insight on this?

    Thank you.
    Saturday, August 30, 2014 4:22 PM

Answers

  • All connections get disconnected an ongoing transactions have to be rolled back. Its like restarting the service, just on the other node.

    Bodo Michael Danitz - MCT, MCITP - free consultant - performance specialist - www.sql-server.de

    • Marked as answer by Samantha v Saturday, August 30, 2014 5:52 PM
    Saturday, August 30, 2014 5:07 PM

All replies

  • All connections get disconnected an ongoing transactions have to be rolled back. Its like restarting the service, just on the other node.

    Bodo Michael Danitz - MCT, MCITP - free consultant - performance specialist - www.sql-server.de

    • Marked as answer by Samantha v Saturday, August 30, 2014 5:52 PM
    Saturday, August 30, 2014 5:07 PM
  • Thank you Bodo for the clarification.

    Saturday, August 30, 2014 5:52 PM
  • My observation were the same. 

    However, is there any official documentation describing the exact behavior.

    Tuesday, September 1, 2015 3:31 PM