up vote 0 down vote favorite
share [g+] share [fb]

The Setup is as follows:

  • 1x Principal
  • 1x Secondary
  • 1x Witness

If the Witness and Principal are gone (Hardware- or networkfailure), the secondary DB stays offline. I know this is by design. But if the Witness comes back up and the principal stays down, there is no switchover. Why?

link|improve this question
86% accept rate
feedback

1 Answer

up vote 0 down vote

DO you have high safety with automatic fail over enabled in your mirroring settings? With out the automatic fail over enabled the witness wont enable the databases on the secondary server.

link|improve this answer
Yes, it's set up to switch automatically and works - IF the witness stays up all the time. – CyberOptic Jan 9 at 12:11
feedback

Your Answer

 
or
required, but never shown
discard

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