Fabiano wrote:

> I read MUCH about avoid firebird problems/corruptions by backup/restore the
> Firebird database eventually. The best approach appears to be every day - in
> my case at night when there's no one connected to database.

You should do a backup nightly, with the database accessible to
customers. Once a week, restore a backup to a different location -
preferably on a different machine, to validate that the backups are
good and can be restored. I wouldn't bother replacing the working
database by taking it down, backing it up, restoring it, and
restarting it unless I knew there was a problem. The regular backups
will force garbage collection. You might reset the selectivity of
indexes weekly as well.

>

Good luck,


Ann