Number of Mirroring witnesses allow


Within database mirroring are you allow more than one witness..?

I have the following setup:

Primary server in Datacentre1 and Failover server in Datacentre2.

Where is the best place to install the witness? We currently have a 3rd datacentre, would the witness be better in there or with the principle?

I am thinking of user SQL Express 2008 as the witness, is this advised?

Thanks in advance.

more ▼

asked Dec 11, 2009 at 08:36 AM in Default

avatar image

10.9k 27 37 37

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Haven't implemented database mirroring, so this is just from what I've read....

One witness only seems to be the setup, as the purpose of the witness is to independently ensure that only one of the instances is serving the database, when the instances lose connection with each other. Not sure how thta would work if you had multiple witnesses, as then you would also need a witness-witness!

Obviously the witness needs to be on a physically different machine to either of the database mirror instances, and keeping it separated into another datacentre could improve your resilience.

SQL Express 2008 can be used as a witness, however Microsoft recommend

that every server instance that is used as a witness correspond to the minimum configuration that is required for the SQL Server Standard version that you are running

more ▼

answered Dec 11, 2009 at 09:01 AM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left

The placement of the Witness would come down to the integrity of your networks. You don't want false failovers.

That being said, I would probably locate it in the DR datacentre so that the Standby and it can form a quorum should the Primary fail and the third datacentre not be accessible for some reason.

more ▼

answered Dec 11, 2009 at 10:17 AM

avatar image

12.1k 30 36 42

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 11, 2009 at 08:36 AM

Seen: 2696 times

Last Updated: Dec 11, 2009 at 09:10 AM

Copyright 2018 Redgate Software. Privacy Policy