RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

not a huge data loss. Glenn Thomas Hvidsten From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 23. september 2015 22:24 To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

On Mon, Sep 21, 2015 at 4:53 AM, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > > > > 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

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

[mailto:firebird-support@yahoogroups.com] Sent: 21. september 2015 22:13 To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off At 11:34 p.m. 21/09/2015, Glenn Thomas Hvidsten g...@vensafe.no [firebird

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

On 22/09/15 10:31, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: > Thanks for all the suggestions so far. > We have already put some of our clients computers on UPS. I'm still > interested in other settings we can enable (or disable) to make the database > server more robust

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

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,

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

upport] Securing database against corruption on systems that suddenly get turned off 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 inter

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

[firebird-support] <firebird-support@yahoogroups.com> Subject: Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off Hey, >> you should at least turn on forced writes so that changes are >> written to the disk immediately (jus

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Hi, 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

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Hey, >> you should at least turn on forced writes so that changes are >> written to the disk immediately (just in case you have not already done >> that). > Where do I find that setting? If you do not know where to find the setting, forced writes are probably on, as this is the default

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

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

[firebird-support] Securing database against corruption on systems that suddenly get turned off

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

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

At 11:34 p.m. 21/09/2015, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: >Thanks for the link. >Without specifically setting a new value, how can I check what setting is >currently in use? In Firebird's ..\bin directory, in a shell, do gstat -h path\to\database Look at the