Subject Re: [firebird-support] Re: *.FDB Lock Not Released when Process Shuts Down
Author David Johnson
On Wed, 2005-07-20 at 08:56 +0000, flipmooooo wrote:
> Users are getting paid for doing data entry on the db, one user might
> have done something wrong deleting/updating data that should not be
> updated/deleted, requests a DB restore to correct what he did ...
> Don't think its that rare.

So an entire day's work is wiped out for a single data entry error?
This is bad, verging on evil.

Construct a mechanism for the users to correct their problems, and
eliminate actual deletes from your design. Instead of deletes, flag
rows as invalid, then after a reasonable period of time, purge
invalidated rows.