[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 906
  • Last Modified:

Can a witness server monitor multiple database mirrors?

I've set up a mirrored database on a SQL 2005 server, with a third instance of SQL Server acting as a witness server.

My question is can you use a single SQL Server instance as a witness server for multipe pairs of mirror servers?  For example, if I have six SQL servers running as three mirrored pairs, can I use a single 7th server to act as a witness for all three pairs?
  • 2
1 Solution
A witness server is a must where the DBA wants to implement automatic failover and the configuration must be in the synchronous operating mode. The witness server is usually on a different computer from the principal and the mirror servers. However, one server can act as a witness for multiple mirror partnerships.

From above post
DarylxAuthor Commented:
Excellent, thank you!

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now