Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have two sql boxes, one primary and one mirror.

The mirror stopped synchronising last night for about 12 hours and so now the primary is transferring about 25GB of logs that built up.

However it's taking a long time.

What happens if the primary falls over (for whatever reason) during this time? Presumably the mirror will take over as primary, but I don't know how much of the transaction logs have been transferred.

share|improve this question
    
IIRC, it won't allow you to fail over (without explicit intervention) until the mirror is in a synchronized state. –  Jon Seigel May 30 at 13:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.