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 09, 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: Yesterday @ 4:57 AM
Points: 875, Visits: 1,760
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: Friday, April 04, 2014 9:29 AM
Points: 2,313, Visits: 1,343
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