The log or differential backup cannot be restored because no files are ready to rollforward

Working with SQL Server sometimes you have to restore your database and sooner or later during the restoration process you can receive the following error message:

Msg 3117, Level 16, State 1, Line 1
The log or differential backup cannot be restored because no files are ready to roll forward.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

You can face with this error message when you are trying to restore a differential database backup.

The log or differential backup cannot be restored because no files are ready to rollforward – Solution

You receive this error message because you haven’t restored SQL Server full backup or it has restored without “WITH NORECOVERY” option. All you need to do, before restore a differential backup, is to make sure that a full database backup was restored with “WITH NORECOVERY” option.

Here you can find the simple example how to restore a differential backup

RESTORE DATABASE AdventureWorks FROM DISK = 'D:AdventureWorks_Full.bak' WITH NORECOVERY
RESTORE DATABASE AdventureWorks FROM DISK = 'D:AdventureWorks_Diff.bak' WITH RECOVERY
[Total: 10    Average: 3.9/5]

Leave a Reply

Your email address will not be published. Required fields are marked *