The mirror database has insufficient transaction log data

When you Setting Database Mirroring if you will get the error message like  "The mirror database has insufficient transaction log data".


The mirror database, "Northwind", 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 taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)

Error : The mirror database has insufficient transaction log data
Solution :
1.. Take the Transaction Log backup from Principal server database and
2. Restore Log on Mirror database
 Restore Log on Northwind from disk = 'c:\mssql\backup\DBP_TLog.TRN' with NORECOVERY
3. Now try to setting up Database Mirroring again from Principal Server

4 comments:

  1. CoolJanuary 11, 2021 at 10:29 AM

    Thank you very much..

    ReplyDelete
  2. sportstalkFebruary 2, 2021 at 12:46 AM

    Wow, What an Excellent post. I really found this to much informative. It is what I was searching for. I would like to suggest you that please keep sharing such type of info. Bet365 Mirror site

    ReplyDelete
  3. RAINWARE HOLDINGSFebruary 17, 2021 at 9:35 PM

    You have shared a nice article here about the home accessories. Your article is very informative and nicely describes the causes and natural remedies of Snoring. I am thankful to you for sharing this article here. Kitchen Sink Tap Online In Malaysia

    ReplyDelete
  4. ShopomoreJune 17, 2021 at 6:24 PM

    Great information, this information is necessary and essential for everyone. I am thankful to you for providing this kind of good information. cool kitchen gadgets online

    ReplyDelete

Subscribe to: Post Comments (Atom)