Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can't restore the log Expand / Collapse
Author
Message
Posted Wednesday, February 23, 2011 11:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 19, 2011 12:38 PM
Points: 1, Visits: 7
I'm backup the database using a job. Backup one filegroup per step. The last step is a transaction backup.

When I'm trying to restore the log backup got following error:
"The log in this backup set begins at LSN 188485000000009400255, which is too recent to apply to the database. An earlier log backup that includes LSN 188485000000007400001 can be restored."

I verified the order of the backup and is the same of the restore but I think the log backup is very close to the last filegroup backup.

I compre the lsn using restore header. The first lsn of the transaction log backup is in the range of the last filegroup backup and the last lsn of the log backup is grater than the last lsn of the last filegroup backup.

Anyone have an idea to restore the log backup?



Post #1068453
Posted Wednesday, February 23, 2011 10:23 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 30, 2014 7:17 AM
Points: 310, Visits: 357
The error indicates an earlier log backup needs to be restored first. Is there any other tlog backup happending on the server before your last tlog backup? Have a look in MSDB of the backup history of your db for the period between your first filegroup backup and your last tlog backup. Also, if you can, post the backup file header info in your restore sequence.
Post #1068658
Posted Wednesday, February 23, 2011 11:03 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Saturday, June 21, 2014 2:00 AM
Points: 343, Visits: 1,517
I compre the lsn using restore header. The first lsn of the transaction log backup is in the range of the last filegroup backup and the last lsn of the log backup is grater than the last lsn of the last filegroup backup.

The first lsn of the trx log backup should be in the range of the first filegroup backup, as only then will it contain all changes made to that filegroup and all other filegroups until the last filegroup has been backed up.

As suggested by John, checking the backup history tables should tell you if another trx log backup was taken before the one made by your job.


Ray Mond
Yohz Software
Providing SQL Server database tools for 9 years and counting.
http://www.yohz.com
Post #1068670
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse