Subject Re: [firebird-support] avoiding corruption?
Author Thomas Steinmaurer
> I am still fairly new to Firebird.
> Are there any best practices for avoiding Firebird database corruption or minimizing database corruption?

* Use Forced Writes ON
* Don't copy the database file while it's in use
* Don't access the database file with e.g. a third-party backup software
while it's in use
* Create backups with gbak and test restore under a different database
than the production database to make sure you have a valid backup
* Don't use nbackup with Firebird 2.1 under high load
* Make sure that you don't hit the max. transaction limit (~ 2 billion)
* Make sure that you don't run out of disk space (AFAIK, although your
database shouldn't get corrupt in that scenario)


Regards,
Thomas