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
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
[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
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
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,
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
[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
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
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
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
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
11 matches
Mail list logo