Hello,

i'm trying to restore a log via trn files.

Now I get the message:
The log in this backup set begins at LSN xxx, which is too late to apply to
the database. An earlier log backup that includes LSN yyy can be restored.
RESTORE LOG is terminating abnormally

My guess is that I am missing an earlier TRN file, but is there a
possability to restore anyway?
So bypass a missing TRN file in sequence?

Thanks in advance,
Marco

> So bypass a missing TRN file in sequence?

No can do. SQL Server would have no way of applying log records reflected in the log backup file is
earlier log backups were skipped. And even if SQL server would do that, you would have an
inconsistent database which is something that SQL server won't give us (at least not on purpose). So
you need to find these missing log backup file or stop at the most recent consecutive one. Stuff
that might you in your quest:

RESTORE HEADERONLY. Check out the various "lsn" columns.
The backup history tables in the msdb database.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Kramer" <Kramer@discussions.microsoft.com> wrote in message
news:A6C3C9B4-E9E4-4BA9-89E9-18E243833558@microsoft.com...
> Hello,
>
> i'm trying to restore a log via trn files.
>
> Now I get the message:
> The log in this backup set begins at LSN xxx, which is too late to apply to
> the database. An earlier log backup that includes LSN yyy can be restored.
> RESTORE LOG is terminating abnormally
>
> My guess is that I am missing an earlier TRN file, but is there a
> possability to restore anyway?
> So bypass a missing TRN file in sequence?
>
> Thanks in advance,
> Marco

This happens when you try to restore transaction log bu you have skipped
one that need to be applied. Try this

1. Restore full backup..
2. if you have any differentail log back up... retore that.. then restore
all the transaction log backup taken after the differentioal backup..
3. if you don't have differentail bakup.. then restore all transaction log
backup.

vinu
http://oneplace4sql.blogspot.com/



"Kramer" <Kramer@discussions.microsoft.com> wrote in message
news:A6C3C9B4-E9E4-4BA9-89E9-18E243833558@microsoft.com...
> Hello,
>
> i'm trying to restore a log via trn files.
>
> Now I get the message:
> The log in this backup set begins at LSN xxx, which is too late to apply
> to
> the database. An earlier log backup that includes LSN yyy can be restored.
> RESTORE LOG is terminating abnormally
>
> My guess is that I am missing an earlier TRN file, but is there a
> possability to restore anyway?
> So bypass a missing TRN file in sequence?
>
> Thanks in advance,
> Marco