3013 Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

3013 Error

Author

Topic

dbrantley
Starting Member

4 Posts

Posted - 2009-06-18 : 09:14:11

I am getting "the log differential backup cannot be restored because no files are ready to rollforward" after I run this script:

RESTORE DATABASE applookup
FROM
DISK = 'z:\applookup.bkp'
WITH REPLACE,
RECOVERY

What does this mean by rollforward?

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-06-18 : 17:43:30

It sounds like you are trying to restore from a differential backup. To do this, you must first restore the database from a full backup with NORECOVERY, and then apply the differential backup.

This command will give you information on what type of backup you have:

restore HeaderOnly from disk = 'z:\applookup.bkp'

CODO ERGO SUM

dbrantley
Starting Member

4 Posts

Posted - 2009-06-23 : 14:34:31

I am actually trying to just do a full restore. How does the script need to look to restore a full backup.

ajay_uiet
Starting Member

9 Posts

Posted - 2009-06-24 : 06:46:37

This error happens when Full back up is not restored before attempting to restore differential backup or full backup is restored with WITH RECOVERY option. Make sure database is not in operational conditional when differential backup is attempted to be restored.

http://blog.sqlauthority.com/2007/09/02/sql-server-fix-error-msg-3117-level-16-state-4-the-log-or-differential-backup-cannot-be-restored-because-no-files-are-ready-to-rollforward/

The following link can be helpful.

dbrantley
Starting Member

4 Posts

Posted - 2009-06-30 : 12:59:52

Thanks for all the help guys! I think I have figured out the issue.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources