Async Mirroring - Large unsent log, but status is still "Synchronized"

• winston Smith

  SSCoach

  Points: 19500

  More actions

  May 9, 2013 at 2:58 am

  #277511

  I have a database mirrored using async mirroring.

  Last night "something" happened to cause a large amount of unsent log on the principal.

  What is strange, is in Mirror monitor, although it shows unsent log of many GB's, the databases still show "synchronized". I would have thought they should be "synchronizing

  Anyone experience this? Is my definition of "Synchronized" in async mirroring incorrect?

• sqlSherwin

  SSCrazy

  Points: 2884

  More actions

  May 14, 2013 at 9:49 am

  #1615080

  Yes as long at the principal is still sending changes and the mirror is applying changes their status will say "synchronized".

  This link explains the mirroring states. http://msdn.microsoft.com/en-us/library/ms189284.aspx