Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Requirements for witness server in a mirroring setup

Status
Not open for further replies.

RRinTetons

IS-IT--Management
Jul 4, 2001
333
0
0
US
I'm checking on my understanding of the requirements for a witness server for use in the mirror set up. It sounds like the witness server can be any version of SQL Server, Enterprise, Standard, Express, Developer or anything else. It also sounds like it can be any version number, i.e.-SQL Server 2008 or SQL Server 2005. It doesn't actually handle any workloads, the server it runs on can be quite modest, even a fairly minimal virtual machine. Since the witness server is required for a quorum if one of the pieces of the mirror goes away, it shouldn't be a complete piece of junk, but it doesn't have to be a powerhouse by any means.

I've got 2 identical, very beefy, pieces of physical hardware for the principal and mirror, both 64-bit machines running SQL Server 2008 R2. I'm just trying to figure out now what do the witness.

-
Richard Ray
Jackson Hole Mountain Resort
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top