The only protection that I found until now is to use forced writes on the database.
this can save you from real troubles. Without this option turned off you might lose some data even when your database is in perfect shape. With forced writes you have the guarantee that at least until the last transaction everything is stored on the disk and only data you might loose is the last transaction that was unable to store it's changes to the disk. If corruption is in the area where index data is stored this is not a problem. You can always backup/restore your database and rebuild the broken indexes. Also another way of protecting your data is to make regular backups. But I'm not sure how you will accomplish this in embedded mode. I always use classic server. Hope this helps. On 21.9.2015 ã. 13:24 ÷., Glenn Thomas Hvidsten [email protected] [firebird-support] wrote: > 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: [email protected] > [mailto:[email protected]] > Sent: 21. september 2015 11:57 > To: [email protected] > Subject: Re: [firebird-support] Firebird Embedded on web hosting > > > > sorry but i didn't understand your point ... can you explain more please ? > > > anyway, since i cannot control where fbembedded put it's lock and trace > files, my only option now is to build firebird from source and change > the directory by hand . > > > **************************************************************************** > > Denne epost har blitt kontrollert for virus av Comendo Norge AS > This e-mail has been scanned for viruses by http://www.comendo.no > **************************************************************************** > > > [Non-text portions of this message have been removed] > > -- Doychin Bondzhev dSoft-Bulgaria Ltd. PowerPro - billing & provisioning solution for Service providers PowerStor - Warehouse & POS http://www.dsoft-bg.com/ Mobile: +359888243116 [Non-text portions of this message have been removed] ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
