none
Will the principal wait for acknowledgement from mirror? RRS feed

  • Question

  • Good Morning Experts,

    A transaction was sent to mirror database and immediately failover occured. The mode is synchronous .Failover is still in progress. Will the principal wait for acknowledgement from mirror?


    Kiran

    Sunday, September 22, 2019 4:03 AM

All replies

  • Hi Kiran,

    To achieve synchronous operation for Database Mirroring, the principal server must wait to commit a transaction on the principal database, until the principal server receives a message from the mirror server stating that it has hardened the transaction log to disk.

    In Synchronous Database Mirroring (High-Safety Mode), only when the partners are connected and the database is already synchronized, manual failover is supported. Automatic failover requires the database must be already synchronized. So, the principal must wait for acknowledgement from mirror when you want to failover in Synchronous Database Mirroring Mode.

    Please refer to Synchronous Database Mirroring (High-Safety Mode) failover.

    Best regards,
    Cathy

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, September 23, 2019 3:14 AM
  • True, but after the failover happens, role reversal takes place right? What about the transaction? 

    Kiran

    Thursday, October 10, 2019 12:24 PM