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.
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
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.
answered Dec 11 '09 at 10:17 AM