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
Author
Message
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: Tuesday, July 15, 2014 7:24 AM
Points: 896, Visits: 1,846
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 9:53 AM
Points: 2,315, Visits: 1,356
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
Post #1452690
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse