Mirroring: what happens if principal loses contact with both mirror and wittness?

Posted by TiborKaraszi on SQL Blog See other posts from SQL Blog or by TiborKaraszi
Published on Fri, 16 Apr 2010 05:46:00 GMT Indexed on 2010/04/16 6:14 UTC
Read the original article Hit count: 243

Filed under:
Imagine a database mirroring setup where you have two LANs with a WAN link in between. Let's call them site A and site B. Say that principal is currently in site A, and both mirror and witness are in site B. I.e., we are running database mirroring with a witness, and assuming we are running safety FULL (synchronous), we have auto-fail over. Now, what is really fail over when it comes to mirroring? the simple answer is that the mirror will finish the recovery process (UNDO) and make the database available....(read more)

© SQL Blog or respective owner

Related posts about availability