Subject Re: [firebird-support] Re: Safe Automation of BackUp/Restore
Author Ann W. Harrison
Adam wrote:
>>Apparently firebird
>>requires regular Backup and Restores.
> Not really. Obviously it requires regular backups in case the
> inevitable happens. If your application is not well written for
> Firebird, it is possible and likely that it unnecessarily keeps old
> versions of records "interesting", and prevents the garbage
> collection from doing its job.

While a backup/restore cycle does fix that, the gfix sweep option is
quicker and can be run on-line.

My suggestion is

nightly backup
gbak -b <database> <backup file>
nightly sweep
gfix -s <database>

monthly restore for sanity checking

gbak -c <backup file> <temporary database>

annually, take the database off-line, back it up, restore it, and
replace the original file with the newly created database.