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