SQL 2008 mirror with SQL 2012 Witness

Answered SQL 2008 mirror with SQL 2012 Witness

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

All Replies

  • Tuesday, November 27, 2012 12:35 AM
    Moderator
     
     Answered

    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:42 AM
     
     
    Thanks, just wanted to be sure.