Tell me more ×
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.
up vote 3 down vote favorite

Can I use SQL 2008 R2 as a Witness Server for 2 instances of SQL 2012 Servers being mirrored?

share|improve this question

1 Answer

up vote 2 down vote accepted

No witness server has to be SQL 2012, you can use SQL Express 2012 though

All server participating in database mirroring should be running same version of SQL server.

Taken from Microsoft SQL Server BOL

Except during an upgrade from an earlier version of SQL Server, the server instances in a mirroring session must all be running the same version of SQL Server. For example, a SQL Server 2005 witness is supported when you are upgrading from a SQL Server 2005 mirroring configuration but cannot be added to an existing or new SQL Server 2008 or later mirroring configuration.

Database Mirroring will be deprecated in future release of SQL Server if possible use AlwasyOn Availability Group

share|improve this answer
Going to try using SQL 2012 Evaluation version - hoping that one will work. Thank you – Dina Jul 16 '12 at 13:46

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.