Rodbracher wrote:

> We are at a point where a number of our customer Firebird v1.0 GDBs
> are 1 - 2 GB in size. The backups take +-40 min and restores even longer.
> The growth rate is fair and I expect the GDB size to be 6 - 8 gb in a
> couple of years. Is this going to mean a backup/restore cycle of near 8
> hours ? A lot of these operations are near 24/7 - 8 hours is a lot of
> down time.

How often do you restore? Even though gbak runs every night, restores are
quite seldom (once a year, maybe twice) except for restores which are just
for testing the validity of the backup. It seems your backups are faster
than mine!

Maybe replicating data to a hot (or lukewarm) standby could be an option?
There has been talk about incremental backups, but not much more (than talk).

> Does anyone know if multi-processors dramatically improve backup/restore
> time ?

Wouldn't think so. But, having the gbak and the IB engine run on a
separate processors should help some.


--
Aage J.