Forced writes are on.
I have not been able to recreate this kind of corruption locally so I don’t
know what kind of errors are appearing. The message about corruption comes from
a service technician in the field.
They usually do have a backup of the database, though, so it’s fortunately not
a
[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
If the computer loses power (and is turned off) when Firebird is writing to the
database, the database may become corrupt.
Are there any firebird settings that can make it so that there is a smaller
chance of database corruption?
Glenn Thomas Hvidsten
From: firebird-support@yahoogroups.com
Where do I find that setting?
Glenn Thomas Hvidsten
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21. september 2015 13:21
To: Glenn Thomas Hvidsten g...@vensafe.no [firebird-support]
<firebird-support@yahoogroups.com>
Subject: Re: [firebird-s
Thanks for the link.
Without specifically setting a new value, how can I check what setting is
currently in use?
Glenn Thomas Hvidsten
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21. september 2015 13:29
To: Glenn Thomas Hvidsten g...@vensafe.no
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
I'm having problems shutting down a databases on the server.
I have followed the instructions in the documentation:
http://www.firebirdsql.org/manual/gfix-dbstartstop.html
And by using the following command the database seems to be shut down:
gfix -user SYSDBA -pas masterkey -shut full -force
And by using the following command the database seems to be shut down:
gfix -user SYSDBA -pas masterkey -shut full -force 0 C:\Database\MyDB.fdb
Why isn’t this command working properly and what can I do to shut down
the database so that I can rename it (in order to restore a backup).