本文介绍了运行收缩文件后无法还原事务日志文件的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
每天我都要运行收缩，事务日志和差异备份.每周运行一次完整备份.当我还原数据库时，它向我显示此消息:
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?
推荐答案
这篇关于运行收缩文件后无法还原事务日志文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！