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