--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > --- 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

When the aplication crashes it stops.

Elisabete

> Alan