none
Database mirroring suspended RRS feed

  • Question

  • Hello,

    I have setup database mirroring between SQL 2016 (Principal) and SQL 2017 (Mirror). Then I failed over the databases from SQL 2016 to SQL 2017. Databases got failed over, but the databases on new Principal (SQL2017) are showing up as Principal, Suspended. I looked at the log file, it appears as below. I tried executing SET PARTNER RESUME, but no luck.

    2019-11-27 09:16:59.00 spid33s     The mirrored database "ABC" is changing roles from "MIRROR" to "PRINCIPAL" because the mirroring session or availability group failed over due to failover from partner. This is an informational message only. No user action is required.
    2019-11-27 09:16:59.07 spid51s     Starting up database 'ABC'.
    2019-11-27 09:16:59.10 spid51s     Parallel redo is started for database 'ABC' with worker pool size [1].
    2019-11-27 09:16:59.12 spid51s     Parallel redo is shutdown for database 'ABC' with worker pool size [1].
    2019-11-27 09:16:59.12 spid51s     Converting database 'ABC' from version 852 to the current version 869.
    2019-11-27 09:16:59.12 spid51s     Database 'ABC' running the upgrade step from version 852 to version 853.
    2019-11-27 09:16:59.12 spid51s     Database 'ABC' running the upgrade step from version 853 to version 854.
    2019-11-27 09:16:59.13 spid51s     Database 'ABC' running the upgrade step from version 854 to version 855.
    2019-11-27 09:16:59.13 spid51s     Database 'ABC' running the upgrade step from version 855 to version 856.
    2019-11-27 09:16:59.15 spid51s     Database 'ABC' running the upgrade step from version 856 to version 857.
    2019-11-27 09:16:59.15 spid51s     Database 'ABC' running the upgrade step from version 857 to version 858.
    2019-11-27 09:16:59.16 spid51s     Database 'ABC' running the upgrade step from version 858 to version 859.
    2019-11-27 09:16:59.16 spid51s     Database 'ABC' running the upgrade step from version 859 to version 860.
    2019-11-27 09:16:59.16 spid51s     Database 'ABC' running the upgrade step from version 860 to version 861.
    2019-11-27 09:16:59.16 spid51s     Database 'ABC' running the upgrade step from version 861 to version 862.
    2019-11-27 09:16:59.18 spid51s     Database 'ABC' running the upgrade step from version 862 to version 863.
    2019-11-27 09:16:59.19 spid51s     Database 'ABC' running the upgrade step from version 863 to version 864.
    2019-11-27 09:16:59.20 spid51s     Database 'ABC' running the upgrade step from version 864 to version 865.
    2019-11-27 09:16:59.20 spid51s     Database 'ABC' running the upgrade step from version 865 to version 866.
    2019-11-27 09:16:59.20 spid51s     Database 'ABC' running the upgrade step from version 866 to version 867.
    2019-11-27 09:16:59.21 spid51s     Database 'ABC' running the upgrade step from version 867 to version 868.
    2019-11-27 09:16:59.21 spid51s     Database 'ABC' running the upgrade step from version 868 to version 869.
    2019-11-27 09:16:59.22 spid51s     Synchronize Database 'ABC' (6) with Resource Database.
    2019-11-27 09:16:59.34 spid51s     CHECKDB for database 'ABC' finished without errors on 2019-11-23 18:17:10.207 (local time). This is an informational message only; no user action is required.
    2019-11-27 09:16:59.37 spid34s     'TCP://SQL2016SERVER:10767', the remote mirroring partner for database 'ABC', encountered error 948, status 2, severity 20. Database mirroring has been suspended.  Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance.
    2019-11-27 09:19:16.10 spid34s     Error: 1453, Severity: 16, State: 1.
    2019-11-27 09:19:16.10 spid34s     'TCP://SQL2016SERVER:10767', the remote mirroring partner for database 'ABC', encountered error 948, status 2, severity 20. Database mirroring has been suspended.  Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance.
    2019-11-27 09:27:36.71 spid34s     Error: 1453, Severity: 16, State: 1.
    2019-11-27 09:27:36.71 spid34s     'TCP://SQL2016SERVER:10767', the remote mirroring partner for database 'ABC', encountered error 948, status 2, severity 20. Database mirroring has been suspended.  Resolve the error on the remote server and resume mirroring, or remove mirroring and re-establish the mirror server instance.


    Can you help how to resume the mirroring.

    Thanks in advance.

    Wednesday, November 27, 2019 12:47 PM

Answers

  • If I read this correctly you are trying to mirror from the (now) Principal on SQL 2017 to a backwards version Mirror on SQL 2016.  That doesn't work.  Your database has been upgraded to 2017:

    ' Converting database 'ABC' from version 852 to the current version 869.'

    Principal and mirror need to be the same, so an upgrade of the 2016 to 2017 is in order here.


    22 years of database experience, most with SQL Server. Please 'Mark as answered' those posts that helped you.

    • Marked as answer by Vicky_SQL_DBA Wednesday, November 27, 2019 1:52 PM
    Wednesday, November 27, 2019 1:22 PM