Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Async Mirroring - Large unsent log, but status is still "Synchronized" Expand / Collapse
Posted Thursday, May 9, 2013 2:58 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, October 7, 2015 7:44 AM
Points: 925, Visits: 1,988
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?
Post #1450942
Posted Tuesday, May 14, 2013 9:49 AM


Group: General Forum Members
Last Login: Tuesday, August 25, 2015 3:02 PM
Points: 2,322, Visits: 1,400
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.
Post #1452690
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse