SQL 2008 mirror with SQL 2012 Witness
-
Monday, November 26, 2012 11:40 PMQuick question, is it possible to have an SQL 2008 replicating to another SQL 2008 with the witness server being SQL 2012?
- Edited by GavinRoss Monday, November 26, 2012 11:41 PM
All Replies
-
Tuesday, November 27, 2012 12:35 AMModerator
No. Per Database Mirroring Witness in 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.
- Marked As Answer by GavinRoss Tuesday, November 27, 2012 12:41 AM
-
Tuesday, November 27, 2012 12:42 AMThanks, just wanted to be sure.

