Subject database maintenance?
Author heineferreira

I come from a SQL Server background.
Obviously on any database, even file-based ones like Access and Paradox
you should perform daily backups. Do you have to perform any maintenance
on a Firebird database? I know on Access databases you must do frequent
compact and repair. On SQL Server you must do database integrity checks.
You must also defrag the database internally. Also, on SQL Server you
must rebuild your indexes from time to time. You have to do these things
manually on SQL Server Express but you can schedule them on the paid
versions of SQL Server. What must you do to maintain a Firebird database
and how do you do it?