none
SQL 2008 mirror with SQL 2012 Witness

    Question

  • Quick 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
    Monday, November 26, 2012 11:40 PM

Answers

  • 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.


    Brandon Williams (blog | linkedin)

    • Marked as answer by GavinRoss Tuesday, November 27, 2012 12:41 AM
    Tuesday, November 27, 2012 12:35 AM
    Moderator

All replies

  • 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.


    Brandon Williams (blog | linkedin)

    • Marked as answer by GavinRoss Tuesday, November 27, 2012 12:41 AM
    Tuesday, November 27, 2012 12:35 AM
    Moderator
  • Thanks, just wanted to be sure.
    Tuesday, November 27, 2012 12:42 AM