Subject Re: Daily Maintenance Task for Firebird
Author Chooi-Ting
--- In, Alan McDonald <alan@m...>
> > Just want to check out what are the daily maintenance tasks
needed to
> > maintain firebird database. Currently I am running 'gbak -B -g'
> > database once a day, and alter index inactive/active. Are them
> > enough to maintain the performance of the database ?
> >
> > chooi
> I wouldn't rebuild my indexes once a day. Maybe as an ad hoc thing
if you
> feel something is wrong with performance but if you backup and
restore your
> db every 3 to six months you'll be rebuilding everything anyway.
> If it's hosted on W32 then make sure forced writes is turned on.
> If the backup/restore cycle is too costly (down time) then
> indexes is an alternative but it won't cure any ills (in my
> Ultimately you need to schedule in the backup/restore cycle and
make your
> uses get used to having this down time on a regular basis.
> You can, on a more regular basis, do a backup, then restore to
another copy
> of the database to ensure that no errors in the restore cycle are
> This copy can be deleted after an error-free restore. Ultimately,
> forced writes on in W32 on not on =nix, the server has always been
> reliable for me.
> Alan

Alan..thanks for your advise.
do we need a downtime for firebird backup/restore function ? I found
that we still can access to the database except that the performance
is effected.