Subject Re: [ib-support] Re: Backing up / Restoring large databases
Author Martijn Tonies
> 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).

Btw, Thomas seems to have a product for incremental backups -
see www.iblogmanager.com


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com