Click here to Skip to main content
15,889,864 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?
Posted
Updated 2-Nov-10 0:22am
v3

1 solution

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,
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900