SharePoint differential restore fails with error "The log or differential backup cannot be restored because no files are ready to roll forward."

Article:TECH70599  |  Created: 2009-01-14  |  Updated: 2014-01-14  |  Article URL http://www.symantec.com/docs/TECH70599
Article Type
Technical Solution


Subject

Issue



SharePoint differential restore fails with error "The log or differential backup cannot be restored because no files are ready to roll forward."


Error



Restore of SharePoint differential backup fails with error: V-79-57344-33938 - The log or differential backup cannot be restored because no files are ready to roll forward.


Cause



This issue occurs because a differential or log restore job has been attempted when the SQL database is in the incorrect state to receive this type of restore.


Solution



In order to perform differential or log restores for a database, that database must have had a full backup restored with the 'NORECOVERY' option first.  The NORECOVERY option leaves the database in a loading or restoring state that allows additional differential or log restores.  Accomplishing this is possible in one of two ways.  The first is to perform an individual full backup restore with the setting 'Bring restored databases online' unchecked, followed by log or differential restore with that setting checked.  The second and simpler method is described below.
 

  1. Restore the entire full backup of SharePoint as well as the differential backup in one job. File | New | Restore Job | View by Resource
  2. Select the full backup of SharePoint resources as well as the desired differential backup.
  3. Select "Microsoft SharePoint" under settings and make sure to check the box for "Bring restored databases online" and "Reconnect previous database links".

     

     
  4. Click on "Run Now" to run the job.
     

Supplemental Materials

SourceUMI
ValueV-79-57344-33938
Description

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



Legacy ID



325161


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


Terms of use for this information are found in Legal Notices