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.

Problem

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.

 

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.

 

Solution

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.

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)