Home / server / Questions / 324184
In Process
CyberOptic
Asked: 2011-10-24 23:58:12 +0800 CST

MSSQL: High-Availability, Witness and Principal down case

  • 772

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?

sql-server high-availability

1 Answers

  1. 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.

    • 0