"Andre" <no*****@nospam.org> wrote in message
news:40***********************@news.xs4all.nl...
Hi,
I have a database (or better: used to have) and backup consisting of
- the initial (complete) database
- all log files since then (or so I thought)
After making a data entry error I wrote the log to the backup and
tried a point of time restore.
Unfortunately that failed with 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."
and left the database in an inaccessible state.
I have tried to reproduce the error, my guess is that the recovery model
was set to 'simple'
instead of ' full' at for some time.
Is there anyway I can
- extract data from the log files (however incomplete)?
- get the database back to the point of just after the database error
(just before I tried the restore)?
Thanks for your time!
Andre
I'm not really sure I follow your description - do you mean that the
sequence of log backups was broken because the database was set to simple
mode, then back to full? So when you restored your logs, only some of them
restored, before giving the error? If so, then you should be able to make it
available again like this:
restore database MyDB with recovery
However you can't roll forward without a full sequence of log backups, so
you won't be able to get back to the point after the error occurred. If the
data is valuable enough, you should probably consider calling Microsoft for
support, but they may not be able to do much either, if you don't have a
valid backup set.
You might be able to recover something from your log backups using a tool
like this one, but if you don't have all the log backups then you won't know
what is missing:
http://www.lumigent.com/products/le_sql/le_sql.htm
If I've misunderstood your situation, or if this isn't helpful, please give
some more detailed information about what happened, what you've tried
(preferably the exact RESTORE commands you used), and the current status of
the database (ie. using DATABASEPROPERTYEX('MyDB', 'Status')).
Simon