|Subject||Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off|
In addition to FW On and UPS, I suggest to look at our tool FBDataGuard (http://ib-aid.com/en/fbdataguard), which is specifically designed to protect databases against corruptions (among other features).
FBDataGuard stores a copy of raw metadata in the repository outside database, and if corruption happens, this repository will be used to recover database with our recovery tool (FirstAID). In our experience such approach increases chances to recover up to 99%.
We have FirebirdSQL (2.1) running on a client computer (Windows). This client has some problems with his power grid which causes the PC to suddenly and unexpectedly shut down in infrequent intervals (usually once or twice per day). Most of the time this doesn’t cause any problems, but once in a while this causes the database to be corrupted.
I’m not at all surprised that the database gets corrupted like this (as turning off a computer without shutting everything down gracefully can have that effect).
Are there any options available that can make a database more sturdy against these kinds of corruptions?