Friday, October 30, 2009

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

Error Msg 3117, Level 16, State 4 
The log or differential backup cannot be restored because no files are ready to roll forward.

The above error occurs when Full back up is not restored before attempting to restore differential backup or full backup is restored with WITH RECOVERY option. 

Here is the query for restoring differential backup: 
Step 1: First restore the full backup through below command. 
RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\AdventureWorks_Full_20091030000000.bak'  
WITH NORECOVERY; 

Step 2: After restoring full backup, now run the below script for restoring differential backup. 
RESTORE DATABASE AdventureWorks
FROM DISK = 'C:\AdventureWorks_Diff_20091030000020.bak'
WITH RECOVERY



how to restore full backup. how to restore differential backup. error while restoring the database in sql server. sql server 2012 restore error. the log backup cannot be restored because no files are ready to roll forward. sql server 2008 database restore error. sql server 2008 r2 error while restoring backup file.

1 comments:

when i restoring fullback
RESTORE DATABASE AdventureWorks
FROM DISK = ‘C:\AdventureWorksFull.bak’
WITH NORECOVERY;
It showing MSg 3159 and asking for replace or stopat option to restore data....
Please suggest solutution.

Post a Comment