The log or differential backup cannot be restored because no files are ready to roll forward is received while running a differential restore of SQL database.
book
Article ID: 100021339
calendar_today
Updated On:
Description
Error Message
V-79-65323-3117 - The log or differential backup cannot be restored because no files are ready to roll forward.
Cause
Restores would fail with above mentioned error if a previous restore job was ran with option "Leave database ready to use. Additional transaction logs cannot be restored" , this option would ensure that SQL Server will roll forward any committed transaction and to roll back any uncommitted transaction. After applying this option, the database is in a consistent state and is ready for use and no further sets can be restored.
Resolution
1. Run a restore of the full backup set with option
"Leave database non operational, additional transaction logs can be restored" to ensure that SQL Server does not roll back uncommitted transactions , and would allow applying further backups. After this option is applied, the database is unavailable for use, and additional transaction logs can be restored. ( Figure 1)
Figure 1
2. Run the last differential set available with option
" Leave database ready to use , additional transaction logs or differential backups cannot be restored." , to ensure that SQL Server will roll forward any committed transaction and to roll back any uncommitted transaction. After applying this option, the database is in a consistent state and is ready for use. ( Figure 2)
Figure 2

For additional information on setting default Backup and restore options in SQL please refer the related documents section below.
Issue/Introduction
The log or differential backup cannot be restored because no files are ready to roll forward is received while running a differential restore of SQL database.
Additional Information
UMI: V-79-65323-3117
Was this article helpful?
thumb_up
Yes
thumb_down
No