locked
mirroring between sql 2012 and sql 2017 RRS feed

  • Question

  • Trying to setup a mirror between a 2012R2 server running sql 2012 std

    and a new 2016 server running sql 2017 std as part of an upgrade.

    The mirroring starts but then the mirror times out trying to reach  the principal.  Service accounts are the same - a domain account, encryption type is the  same, endpoints are listening, firewalls off.

    Error 1479 and also this error

    Database mirroring connection error 4 'An error occurred while receiving data: '10054(An existing connection was forcibly closed by the remote host.)'.' for 'TCP://xxxx:5022

    Has anyone been able to mirror a sql 2012 db to a sql 2017 instance?

    Sunday, November 12, 2017 9:55 PM

Answers

  • Hi neildba,

    As mentioned in the document: Prerequisites, Restrictions, and Recommendations for Database Mirroring -> https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/prerequisites-restrictions-and-recommendations-for-database-mirroring, "For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server", it is not supported to create database mirroring between SQL Server 2012 and SQL Server 2017.

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Monday, November 20, 2017 1:35 AM
    • Marked as answer by neildba Monday, November 20, 2017 3:06 AM
    Monday, November 13, 2017 1:41 AM

All replies

  • Hi There,

    It do not work due to incompatibility. you can backup 2012 databses and restore to 2017.

    but you can not mirror from 2012 to 2017.

    where as in 2017 even if you create 2012 compatibility you still can not restore the database to 2012.

    thanks

    kumar

    Monday, November 13, 2017 1:11 AM
  • Hi neildba,

    As mentioned in the document: Prerequisites, Restrictions, and Recommendations for Database Mirroring -> https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/prerequisites-restrictions-and-recommendations-for-database-mirroring, "For a mirroring session to be established, the partners and the witness, if any, must be running on the same version of SQL Server", it is not supported to create database mirroring between SQL Server 2012 and SQL Server 2017.

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Monday, November 20, 2017 1:35 AM
    • Marked as answer by neildba Monday, November 20, 2017 3:06 AM
    Monday, November 13, 2017 1:41 AM
    1. Make sure that the power plan for the mirrored server is set to high performance
    2. Make sure the host machine for the  mirrored VM is also set on high performance
    3. Make sure the host machine for the mirrored VM at the BIOS level has no power saving options enabled
    Monday, November 13, 2017 5:21 AM
  • Both SQL server versions should be same to create Mirroring. If any of the versions are different you cannot create mirroring, hence you were receiving the errors.

    Thanks

    Thursday, November 16, 2017 8:14 AM