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

I need some clarification on mirroring Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 7:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 7:09 AM
Points: 139, Visits: 403
Hi All

Here we have configured the mirroring. but in mirroring data not synchronized from last 10 hours how to solve the issue. and how can I find whether it is synchronized or not.

here we have do the failover of mirror server whether is it applicable immediately or it will take time for fail over?

how to do the fail over in this scenario?


Post #1473017
Posted Friday, July 12, 2013 11:45 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 4:56 PM
Points: 31,168, Visits: 15,612
Is it way behind? Have you looked in BOL for the "Monitoring Mirroring Status"?

It could be always slightly behind, depending on how your system is setup and your network.

In a failover, if it's behind, you lose data.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473177
Posted Friday, July 12, 2013 2:52 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 16, 2014 8:54 AM
Points: 727, Visits: 1,424
A couple of really good links for you to learn and hopefully help you:

http://msdn.microsoft.com/en-us/library/ms190030.aspx
http://msdn.microsoft.com/en-us/library/ms189931.aspx

One of the items I watch is the RedoQueueKB. Tells you how much data would need to be applied on the mirror during a failover before the database would come online.

http://msdn.microsoft.com/en-us/library/cc917681.aspx

Hope they help.

Fraggle
Post #1473238
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse