运行收缩文件后无法还原事务日志文件 [英] Can't restore transaction log file after run shrink file

问题描述

每天我都要运行收缩，事务日志和差异备份.每周运行一次完整备份.当我还原数据库时，它向我显示此消息:

Every day I run shrink, transaction log and differential backup. Weekly runs the full backup. When I restore the database it show this message to me:

Processed 6536 pages for database ''project2'', file ''project2'' on file 1.
Processed 2 pages for database ''project2'', file ''project2_log'' on file 1.
RESTORE DATABASE successfully processed 6538 pages in 11.888 seconds (4.505 MB/sec).
Processed 0 pages for database ''project2'', file ''project2'' on file 1.
Processed 4 pages for database ''project2'', file ''project2_log'' on file 1.
RESTORE LOG successfully processed 4 pages in 0.046 seconds (0.567 MB/sec).
Msg 4312, Level 16, State 1, Line 4
This log cannot be restored because a gap in the log chain was created. Use more recent data backups to bridge the gap.
Msg 3013, Level 16, State 1, Line 4
RESTORE LOG is terminating abnormally.
Msg 3136, Level 16, State 1, Line 6
This differential backup cannot be restored because the database has not been restored to the correct earlier state.
Msg 3013, Level 16, State 1, Line 6
RESTORE DATABASE is terminating abnormally.

如何解决此问题?

How can I solve this problem?

推荐答案

我搜索了以下两个链接，这些链接可能对您提到的问题已解决很有用！！！

http://www.sqlservercentral.com/Forums/Topic654643-146-1.aspx#bm654805

这是msdn的另一篇文章，也提供了见识

http://social.msdn.microsoft.com /forums/zh-CN/sqldisasterrecovery/thread/e9befa5a-fe72-4157-a2b9-7f4ce22c0253/

希望您能从以上两个帖子中得到解决方案！

谢谢
Arindam D Tewary，

Hi,

I searched and following two links which might be usefull as your mentioned issue was solved !!!

http://www.sqlservercentral.com/Forums/Topic654643-146-1.aspx#bm654805

This is another post from msdn which also gives an insight

http://social.msdn.microsoft.com/forums/en-US/sqldisasterrecovery/thread/e9befa5a-fe72-4157-a2b9-7f4ce22c0253/

I hope you get a solution from above two post!!

Thanks
Arindam D Tewary,

这篇关于运行收缩文件后无法还原事务日志文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！