Subject | Re: [firebird-support] Removing deadlocks via Backup/Restore. |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2009-05-04T13:36:32Z |
From: "Helen Borrie"
app for a second and stop the Firebird Service with the Firebird Server Control
and restart it. Is it not enough?
Thanks!
Sergio.
> But you don't need a backup/restore to resolve these occasional deadlocks.Hi Elen! When I have this kind of problem I just ask all the users to exit the
> 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.
app for a second and stop the Firebird Service with the Firebird Server Control
and restart it. Is it not enough?
Thanks!
Sergio.