--- 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 problema about using gbak is that it can take too long and
> > during that time my clients can't get the information they need.
>
> With Firebird 2.0, there's a new backup utility called NBACKUP that
> will be faster than GBAK and will provide a backup file that can be
> used as a database. At the moment don't ask when will Firebird 2.0
> will be officially released, it's still in Alpha.
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Consultants Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)