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