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
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
Thank you very much..
ReplyDeleteWow, 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
ReplyDeleteYou 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
ReplyDeleteGreat 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