question

5QL53rv3r avatar image
5QL53rv3r asked

Witness disconnected

if the witness server in a mirrored setup is disconnected (in this case removed for H/W maintenance due to a disk failure) will the mirror setup be maintained? I have a principal, mirror and witness 3 server setup.

database-mirroringwitness
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered

As the witness is just one of the three servers, if it fails it does not mean that a failover will occur.

As long as the principal and mirror can still communicate then failover will not occur.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered

I agree with Jonlee (+1) but would add that if there is an issue with the principal, during the downtime, and the mirroring was set up for auto-failover then it will not occur as the quorum wont be present to make the decision - there need to be two votes to make the failover - ie Witness and Mirror both agree the principal is not available and therefore the failover should take place. Hopefully if this is just maintenance then the situation shouldnt occur

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.