Can I use SQL 2008 R2 as a Witness Server for 2 instances of SQL 2012 Servers being mirrored?
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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
Database Mirroring will be deprecated in future release of SQL Server if possible use AlwasyOn Availability Group