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?