2

In a SQL Server FCI configuration, what happens to transactions that are in flight when the failover event happens? 1. If the transaction is committed just before the server crashes 2. If the transaction is just about to be commited and the failover event occurs.

Does a message get sent to the application? If the user has not yet commited and the failover happens, does the user get a message that the transaction is rolled back or what exactly happens to help the user know what to do?

From what I have read, the failover is automatic and it is transparent to the user. Is this completely true?

Thank you.

Improve this question
2
  • Point of clarification. Failover can be automatic, or you can elect to control when it happens. You may wish to control it in order to prevent ping-pong failovers.
    – Jonathan Fite
    Commented Jun 3, 2021 at 16:43
  • @JonathanFite, thanks, helpful comment, appreciated.
    – PTL_SQL
    Commented Jun 4, 2021 at 11:42

1 Answer 1

Reset to default
4

On failover the clients' network connections are broken, and in-flight transactions are rolled back as part of the recovery process on the other server. The client will get an error message, most often related to the broken connection, and will need to reconnect to the server.

Clients without an in-flight transaction may be transparently reconnected to the new server.

Improve this answer
1
  • thank you so much for that helpful response, very much appreciated.
    – PTL_SQL
    Commented Jun 4, 2021 at 11:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.