Subject | Re: [firebird-support] Can I use gfix to fix database while it is being used (online) by clients? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-03-10T20:46:43Z |
Hello Aage,
attachment with gfix.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
> > I am a database administrator trying to fix a 2GB firebird ver1.5gfix can't be run while others are connected. You need to be the only
> > database being used in a hospital. I cannot afford to shutdown the
> > database as this is a 24/7 operation.
> > I had copied the database file (inside REdhat Linux) to my PC and doing
> > a (local) gfix (-v -full/-mend) but the number of errors is still the
> > same. I have not tried doing it for the live database.
> > I cannot backup using IBExpert. Error is "Arithmetic overflow...".
>
> As for gfix'ing the database with users still connected, I would be
> very reluctant.
attachment with gfix.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com