Post reply

When AG Failovers , what happens to open txns ?

  • November 28, 2019 at 7:16 am

    #3701842

    Hi All,

    Need help in understanding the behavior when AG fails over to other nodes.

    Assume that 10 SPID'S have started a transaction and doing some DML operations. In the middle AG fail over happened,

    what happens to those 10 open txns ?

    Env : SQL 2012 and 2016 EE

    Regards,

    Sam

  • November 29, 2019 at 1:09 am

    #3702010

    Open transactions at the time of an AG failover experience the same thing as they would when you force the database offline or the server crashes: those transactions will be rolled back during the UNDO phase of database recovery on the new Primary replica, performed as part of switching roles on the new Primary.

    Eddie Wuerch
    MCM: SQL

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

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