Microsoft SQL Server mirror database Error 1478

Keke Yuan 21 Reputation points
2021-12-10T05:35:32.637+00:00

Error msg: (Microsoft SQL Server, Error 1478): The mirror database has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been restored on the mirror database. 

Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
476 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,517 questions
{count} votes

Accepted answer
  1. YufeiShao-msft 7,041 Reputation points
    2021-12-10T06:12:16.117+00:00

    Hi @Keke Yuan

    When starting the synchronization for database mirroring, you may get the above error, mirroring requires a full restore and at least one tlog restore, the error is dur to the mirror database has insufficient transaction log data
    To start the synchronization successfully, you can do following steps:

    Principal Instance - - Take a full backup and a log backup as well, Copy the full/log backups from Principal Instance to Mirror instance
    Mirror Instance - - Restore with NORECOVERY option the full backup
    Mirror Instance - - Apply the log backup
    Principal Instance - - Start synchronization

    -------------

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful