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

5 comments:

  1. I will share it with my other friends as the information is really very useful. Keep sharing your excellent work.Latest Football Transfer News

    ReplyDelete
  2. 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. 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. 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