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.

Article:TECH71884  |  Created: 2010-01-26  |  Updated: 2013-04-09  |  Article URL http://www.symantec.com/docs/TECH71884
Article Type
Technical Solution

Product(s)

Subject

Issue



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



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.

Supplemental Materials

SourceUMI
ValueV-79-65323-3117
Description

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

 


Legacy ID



327154


Article URL http://www.symantec.com/docs/TECH71884


Terms of use for this information are found in Legal Notices