Subject Re: [firebird-support] Removing deadlocks via Backup/Restore.
Author Sergio H. Gonzalez
From: "Helen Borrie"
> But you don't need a backup/restore to resolve these occasional deadlocks.
> You can do a full database shutdown (not even with exclusive access) - rename
> the database file if you have users who can log in as SYSDBA or owner - then
> run a gbak backup or a sweep to clean out garbage - rename back to the proper
> name - and put it back online.


Hi Elen! When I have this kind of problem I just ask all the users to exit the
app for a second and stop the Firebird Service with the Firebird Server Control
and restart it. Is it not enough?

Thanks!
Sergio.