A problem with one of our database tables arose at the end of last week and I wanted to restore that database to a server in order to retrieve the table. We only have the last backup, and a full set of transaction logs before the error occurred, up to and after the full back was taken.
However, when I restore, I can only use the transaction logs to roll forward, not back. Is what I'm trying to do possible?
Sequence of events:
- Error occurred: Friday April 5 at 12:00
- Full backup taken: Sunday April 7 at 02:00