Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Must all db servers be running the exact same version to enable mirroring without a witness server? How about with a witness server in place?

share|improve this question

1 Answer 1

up vote 3 down vote accepted

The partners must be the same edition and the same version.

Please see BOL's reference on Database Mirroring Overview

For a new mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server.


Since SQL Server 2005 Service Pack 1 (SP1), database mirroring partners and witnesses have been supported by Standard and Enterprise Edition. But the partners must use the same edition, and asynchronous database mirroring (high-performance mode) is supported only by Enterprise Edition. Witnesses are also supported by Workgroup Edition and Express Edition.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.