[Webinar] Streamline your web hosting managementRegister Today

x
  • 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?
0
Darylx
Asked:
Darylx
  • 2
1 Solution
 
slam69Commented:
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
0
 
DarylxAuthor Commented:
Excellent, thank you!
0

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