Subject | Re: [firebird-support] avoiding corruption? |
---|---|
Author | Thomas Steinmaurer |
Post date | 2012-10-14T09:36:50Z |
> I am still fairly new to Firebird.* Use Forced Writes ON
> Are there any best practices for avoiding Firebird database corruption or minimizing database corruption?
* 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