Subject Re: Shred records
Author Adam
> Hello Ivan. In your opinion, does a SWEEP make any difference in
> making it more difficult or impossible to recover committed deleted or
> updated records? I have a very paranoid client. Thanks, Hugo


You have already been advised that a sweep does not remove the data
from the file. I don't know what else to tell you.

Tell your customer to store their data on an encrypted volume and be
done with it. Firebird was not designed to securely remove data that
has been deleted with a 35 pass random data overwrite pattern. The
data remains on the page until it is overwritten by something else.

If you back up a database, the deleted records will not be in the
backup file, so you can securely purge it. But if you are going to be
paranoid, you might as well go the whole hog and make sure you encrypt
the sort directories and you better have your virtual memory page file