I
I
ITF2022-01-17 07:20:07
Database administration
ITF, 2022-01-17 07:20:07

Why can't I restore a differential backup?

spoiler
61e4f68fb9505330471170.jpeg
According to the maintenance plan, a full backup should have been made in the morning. During the day - differentials once an hour. In the evening, all this is packed and carried. The next day - in a new file in a circle.
At some point, a full backup could not be made (the skl could not access the file) and he missed the task - he made a diff to a new file.
According to the recovery chain - it seems to be loaded, but for some reason it writes an error:
System.Data.SqlClient.SqlError: Невозможно восстановить журнал или разностную резервную копию, 
так как нет файлов, готовых к накату.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2022-01-17
@tsklab

be transferred
Check back the full backup file.

I
ITF, 2022-01-17
@ITF

Remove the question. Problem with "WITH RECOVERY" modes
In MS SQL 2008 R2, if you clicked with the mouse, you had to put down: "Leave the database in an idle state and do not roll back uncommitted transactions", i.e. RESTORE WITH NORECOVERY

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question