Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm at the early stages of implementing a high availibilty solution using SQL 2008.

With regard to database mirroring I believe that under the syncronous model, transactions are not committed on the principal server until they are committed on the mirror server. If the principal server fails then failover can either be automated using a witness instance of performed manually.

In this mode, what happens should the mirror server fail?

Would the principal be unable to commit transactions? or does the mirror break?

I'm concerned that the principal is at the mercy of the mirror.

share|improve this question

Cool - just note that if you are using a witness, a "quorum" between principal, witness, and mirror is required. If you lose the mirror and the witness (or connectivity to both), the principal database will not be available.

share|improve this answer
thank you, i had planned on using a witness but haven't got that far with it yet, if I had two witnesses and a mirror (which is what i'm planning), would I need to lose all three before the principal becomes unavailable? – Chris Diver Jul 23 '10 at 16:23
Hi Chris - I believe you can only have one witness per mirrored pair of databases. – Brian Knight Jul 23 '10 at 16:46
Oh well that won't work then. Thanks for the info and the link, i'll have a read. – Chris Diver Jul 23 '10 at 17:03
up vote 0 down vote accepted

Found the answer.

The loss of a partner has the following effect:

  If the mirror server instance becomes unavailable, the principal continues.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.