Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Today @ 7:52 AM
Points: 927, Visits: 2,034
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: Monday, October 10, 2016 9:24 AM
Points: 2,337, Visits: 1,417
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