Can a 2012 SQL instance be used as the witness for a 2014,2016 database mirroring setup?

  • Hi All,

    Can we have a sql witness server with 2012 version to support 2014 and 2016 Database mirroring setup?
    so i need confirmation from experts that can we use the same witness server with 2012 version to setup DB mirroring with  automatic failover configuration being Principle and Mirror servers (both either are in 2014 or 2016 version?) 

    1st scenraio-Like Witness in SQL 2012, Principle and Mirror in SQL 2014
    2nd Scenario - Witness in SQL 2012, Principle and mirror in SQL 2016.

  • muth_51 - Thursday, June 14, 2018 9:40 AM

    Hi All,

    Can we have a sql witness server with 2012 version to support 2014 and 2016 Database mirroring setup?
    so i need confirmation from experts that can we use the same witness server with 2012 version to setup DB mirroring with  automatic failover configuration being Principle and Mirror servers (both either are in 2014 or 2016 version?) 

    1st scenraio-Like Witness in SQL 2012, Principle and Mirror in SQL 2014
    2nd Scenario - Witness in SQL 2012, Principle and mirror in SQL 2016.

    Needs to be same version. It's listed in the prerequisites for DB Mirroring:
    Prerequisites, Restrictions, and Recommendations for Database Mirroring

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply