can't restore differential backup and tracsaction log.
-
I do every day differential backup, transaction log and shrink file, weekly full backup.when i restore database, it show this message: 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 12.534 seconds (4.273 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.048 seconds (0.544 MB/sec). Msg 4312, Level 16, State 1, Line 3 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 3 RESTORE LOG is terminating abnormally. 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 5 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 5 RESTORE DATABASE is terminating abnormally. how can i solve this problem.
-
I do every day differential backup, transaction log and shrink file, weekly full backup.when i restore database, it show this message: 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 12.534 seconds (4.273 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.048 seconds (0.544 MB/sec). Msg 4312, Level 16, State 1, Line 3 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 3 RESTORE LOG is terminating abnormally. 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 5 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 5 RESTORE DATABASE is terminating abnormally. how can i solve this problem.
First do not shrink the file.