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.