Post reply

synchronous database mirroring auto failover.

  • January 24, 2015 at 7:19 pm

    #314062

    I have a general question about when a database failover in a mirroring session. what happens if a transaction is written to the primary and the primary fails before it gets written to the secondary? Will it still automatically failover? If it does failover, does the application receive an error that the transaction failed?

  • January 25, 2015 at 1:02 pm

    #1772969

    I hate to say it depends, but it does. If you start a synchronous transaction on the primary, and it can't be committed to the mirror, it doesn't get committed to the primary. It has to commit on the mirror before it's hardened on the secondary. It goes through rollback, depending on when the failover occurs.

    Does the client get an error? They should certainly get an error that their connection is broken to the primary because they have an open session and never got an acknowledgement of commit.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply