LSN Sequence Issue

HI
I have full backup of 17th & lost the file of full backup
of 13th. I have transaction log backups from their
onwards. I need to restore data from 15th & 16th from
transaction logs. Its very critical. When I apply the
transaction log on 17th restore in loading mode it says
apply current transaction log having so & so lsn number.
What is the alternative to get that critical data.
Thanks,
ManojAfter you restore the backup from the 17th, you can only restore log backups
taken after that point.
SQLServer doesn't provide any tool to extract the data from the log only.
There may be tools, from companies such as "Lumigent" which would allow you
to extract the inserts/deletes/updates from the log.
"Manoj" <mgmanoj@.hotmail.com> wrote in message
news:0e7501c3846c$6b60b460$a101280a@.phx.gbl...
> HI
> I have full backup of 17th & lost the file of full backup
> of 13th. I have transaction log backups from their
> onwards. I need to restore data from 15th & 16th from
> transaction logs. Its very critical. When I apply the
> transaction log on 17th restore in loading mode it says
> apply current transaction log having so & so lsn number.
> What is the alternative to get that critical data.
> Thanks,
> Manoj|||Do you have the "next latest" db backup? And all subsequent log backups? If so, you can restore from
that thanks to SQL Server not truncating the log when you do db backup.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Manoj" <mgmanoj@.hotmail.com> wrote in message news:0e7501c3846c$6b60b460$a101280a@.phx.gbl...
> HI
> I have full backup of 17th & lost the file of full backup
> of 13th. I have transaction log backups from their
> onwards. I need to restore data from 15th & 16th from
> transaction logs. Its very critical. When I apply the
> transaction log on 17th restore in loading mode it says
> apply current transaction log having so & so lsn number.
> What is the alternative to get that critical data.
> Thanks,
> Manoj