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

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