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
