Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  High Availability (2008)  placement of witness server

Author  Topic  butre Starting Member 1 Post Posted - 2010-10-14 : 04:53:02 hi i am looking for some advice on the placement of a witness server i have 1 office with a comms room and a DR site i have 1 sql server which is mirrored with a sql server in the DR site. 1 database (blackberry server database) is mirrored between these 2 sql servers. (windows 2008r2 and sql 2008r2 i have also configured a witness server (sql express 2008r2) and have placed it in the DR site. automatic failover is working fine. there is 1 flaw with this setup, yesterday i had to reconfigure the switch in the DR site and all the servers (including the sql server) were shutdown. the principal sql server in the office went offline as the quorom was broken, the solution would be to place the sql witness server in the office rather than in the DR site but that would mean if the office site would become unavailable i could not failover to the DR site sql server as the witness server would not be able to communicate with the mirror sql server telling it to become the principal. does anyone have any idea how i could solve this issue? many thanks