Question on sql cluster failover behaviour

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.

Answer 1

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

Answer 2

Thank you Bodo for the clarification.

Answer 3

My observation were the same. 

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