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: Thursday, February 26, 2015 7:26 AM
Points: 912, Visits: 1,924
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: Friday, February 27, 2015 1:53 PM
Points: 2,321, Visits: 1,377
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