| Subject | Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off |
|---|---|
| Author | Kevin Meyers |
| Post date | 2015-09-21T16:49:57Z |
Glenn,
My suggestion is to connect the computer in question to an Uninterruptable Power Supply (UPS), which contains a battery as a power backup. When it senses a complete power loss (blackout), an undervolt (brownout), or an overvolt it immediately switches the source of power for your computer from the wall outlet to the battery. One power is restored, the UPS switches back to the wall outlet AC and recharges the battery.
Most units except for the smallest ones come with a USB cable and software to connect to the computer so that if it using the battery and the battery drains it instructs your computer to perform a Shutdown. This would give you the "soft landing" to avoid the corruption you are encountering.
With mine I find that sometimes the momentary loss of power is so short that I don't even notice it, but the UPS does as I hear it click on for few seconds. I'm glad the UPS catches them, because I'm sure my PC notices them.
Hope this helps.
Regards,
Kevin Meyers
On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten glhv@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
Hi,
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?
Cheers
Glenn Thomas
Denne epost har blitt kontrollert for virus av Comendo Norge AS
This e-mail has been scanned for viruses by Comendo Norge AS