> --- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>
> wrote:
> > Hi,
> >
> > At June 21, 2005, 10:42, lsbtreis wrote:
> >
> > >> Bottom line - I would definitely change my procedure to NOT copy
> > > the
> > >> database. I would back it up using gbak. Only take the db
> offline
> > > when you
> > >> want to restore from a backup.
> > >>
> > > Are there no risks of doing backup while the database is in use?
> >
> > If you mean by simply doing a straight file copy, then there is
> always
> > the risk of causing a database corruption.
>
> No I mean running gbak with the database file in use.
>
> Now I close all connections to the database and shutdown the database
> before copying the file, this is way I don´t understand why the
> database file grows. It just happens when one of the aplications
> crash. In this case the connections and transactions are still open.
> Can this be the reason? If so is there a way I can force all orphan
> connections and transactions to close?
>
> thanks
>
> Elisabete

the fastest and most brutal way is to stop the service. The less brutal way
is to use gfix shutdown but sonce you use SYSDBA, then users will not be
barred from making new connections.
When an application crashes - does it stop or does it appear locked but
continuing to be running at high CPU useage? If the latter, then that's the
problem.
Alan