The log or differential backup cannot be restored

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

SQL Server 2005 Forums

Other SQL Server Topics (2005)

The log or differential backup cannot be restored

Author

Topic

senthilavs
Starting Member

5 Posts

Posted - 2010-10-24 : 22:17:40

Hi,

I am running the following script to attempt a restore of a Transaction Log backup. Following methods i done to recover the Log.
1. Right click the Database, Select the Task and click the Backup. Backup Up Database dialog editor popup.
2. From the Dialog i select the "Transaction Log" from Backup Type.
3. After the above steps done i run the following scripts and i got the below error.

RESTORE LOG TEST FROM disk='C:\TEST.trn' WITH RECOVERY, STOPAT = 'Oct 24, 2010 02:10 PM';

Error Occured:
--------------
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 LOG is terminating abnormally.

Thanks,
Senthil Varadharajan.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-24 : 22:23:14

You haven't restore the full backup yet. And with that, you'll need to specify WITH NORECOVERY (RESTORE DATABASE ... WITH NORECOVERY) in order to apply additional files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

senthilavs
Starting Member

5 Posts

Posted - 2010-10-25 : 03:00:09

Hi Tara Kizer,

AS per your reply i done the steps and i got the following error.

Error:
-----
Msg 4305, Level 16, State 1, Line 1
The log in this backup set begins at LSN 233000000015900001, which is too recent to apply to the database. An earlier log backup that includes LSN 198000000111500001 can be restored.
Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

Whether its possible the recover the old data by using the Transaction Log or not.

Thanks,
Senthil Varadharajan.

quote:
Originally posted by tkizer

You haven't restore the full backup yet. And with that, you'll need to specify WITH NORECOVERY (RESTORE DATABASE ... WITH NORECOVERY) in order to apply additional files.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2010-10-25 : 06:00:08

You have missed a Transaction Log file. You need to apply EVERY Transaction Log that was made after the Full backup (which you have restored), in order, up to the final transaction log you want to restore to.

You are trying to restore:
LSN 233000000015900001

The system says that you need to first restore:
LSN 198000000111500001

You can, no doubt, see that the bottom number is smaller/"earlier" than the top number.

If you no longer have that Transaction Log file you can no longer make the restore.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources