Subject Re: [firebird-support] Re: Shred records
Author Helen Borrie
At 07:54 PM 28/04/2007, you wrote:

>I was actually trying to find the answer to my question by researching
>if it's possible to retrieve deleted records. As you say there are
>some ways achieving this with tools such as IBundelete or hexeditors.
>Can I conclude that the Nature of Firbird makes it impossible to
>recover deleted or updated records once the database performs a SWEEP?

To all intents and purposes, yes.

>That is if the delete or update is committed properly.

Well, that's am interesting one. As far as I'm aware (though Alexey
or Ann could put me right) the record versions left over as a result
of limbo transactions don't disappear in a sweep until and unless
they first get flagged as rolled back by a gfix limbo cleanup. If
that's so then theoretically, if you knew what you were looking for,
you could find those strays with a hex editor.