Need restore help...

Hi,
I am trying to find out where SQL Server 2000 writes
when and which last position of a transaction log was
restored. I am restoring full database backup,
differential backup and multiple transaction logs.
Full backup = 1 x week
Differential backup = 6 x week
Transaction log backup = hourly
I am restoring this to another server via SQL Server
Agent jobs. When I get the error of:
The log in this backup set begins at LSN
39300000000091600001, which is too late to apply to
the database. An earlier log backup that includes LSN
38932000000015600001 can be restored. [SQLSTATE 42000]
(Error 4305) RESTORE LOG is terminating abnormally.
[SQLSTATE 42000] (Error 3013). The step failed.
There must be a comparison going on somewhere... where
there is some value that gives the last position or
number of the last time a transaction log was restored.
I am hoping that someone from microsoft comes to my
rescue or anyone else who knows where i can find this
information. This is very valuable information that will
help in releaving this error from happening.
Please advise...
Cheers!
Brettif you do
RESTORE HEADERONLY FROM ...
you will see the first LSN and last LSN.
"Brett" <anonymous@.discussions.microsoft.com> wrote in message
news:084d01c3d6e3$30e1a3c0$a001280a@.phx.gbl...

quote:

---

> Hi,
> I am trying to find out where SQL Server 2000 writes
> when and which last position of a transaction log was
> restored. I am restoring full database backup,
> differential backup and multiple transaction logs.
> Full backup = 1 x week
> Differential backup = 6 x week
> Transaction log backup = hourly
> I am restoring this to another server via SQL Server
> Agent jobs. When I get the error of:
> The log in this backup set begins at LSN
> 39300000000091600001, which is too late to apply to
> the database. An earlier log backup that includes LSN
> 38932000000015600001 can be restored. [SQLSTATE 42000]
> (Error 4305) RESTORE LOG is terminating abnormally.
> [SQLSTATE 42000] (Error 3013). The step failed.
> There must be a comparison going on somewhere... where
> there is some value that gives the last position or
> number of the last time a transaction log was restored.
> I am hoping that someone from microsoft comes to my
> rescue or anyone else who knows where i can find this
> information. This is very valuable information that will
> help in releaving this error from happening.
> Please advise...
> Cheers!
> Brett
>

---