Friday, June 24, 2011

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

-- Part 01
-- Check backup information
RESTORE FILELISTONLY   
  FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_FULL.bak'


-- Restore Database with FULL Backup
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_FULL.bak'
WITH NORECOVERY


-- Part 02
RESTORE FILELISTONLY   
  FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_DIFF.bak'


-- Restore Database with  Differential Backup
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_DIFF.bak'
WITH NORECOVERY


-- Part 03
RESTORE FILELISTONLY   
  FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_01.Log'


-- Restore Database with Log Backup 
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_01.log'
WITH NORECOVERY


RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_02.log'
WITH NORECOVERY


-- Final log with Recovery
RESTORE DATABASE AdventureWorksR2
FROM DISK = 'E:\MSSQL\Backup\AdventureWorksR2_LOG_03.log'
WITH RECOVERY

2 comments:

venkat said...

Hi,


Here the scripts which were you people was gave those are correct but those scripts are not useful for troubleshoot on Msg 3117, Level 16, State 1, Line 1
The log or differential backup cannot be restored because no files are ready to rollforward.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


so could u post exact solution for this.

Thanks for keep on giving solution for us.

SQLDBA said...

Follow the steps begning with full backup then differntial backup then Log backups. Finally restore backup with Recovery mode. If you still facing same issue please contact Microsoft Customer support.