Will the principal wait for acknowledgement from mirror?

  • coolchaitu

    SSChampion

    Points: 10271

    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?

  • Site Owners

    SSC Guru

    Points: 80379

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • bhanumurthy

    Newbie

    Points: 5

    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.

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

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