Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!aioe.org!.POSTED!not-for-mail From: Graeme Geldenhuys Newsgroups: comp.databases.ms-sqlserver Subject: Re: power loss DB corruption Date: Wed, 02 Jul 2014 22:28:43 +0100 Organization: Aioe.org NNTP Server Lines: 26 Message-ID: References: NNTP-Posting-Host: AiRFf5Psbmp5ZfzUflr0xA.user.speranza.aioe.org Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@aioe.org User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0 X-Notice: Filtered by postfilter v. 0.8.2 Xref: csiph.com comp.databases.ms-sqlserver:1781 On 2014-04-25 08:43, Hendrik van der Heijden wrote: > I get database corruption on hard shutdowns and wonder if there's > some way to fix this. I googled a lot but couldn't find an answer > whether this is supposed to work at all. The company I worked for in South Africa has done extensive tests on power loss and OS & DB corruptions. South Africa is very prone to blackouts and brownouts. We have found that at file system level, the JFS (originally developed by IBM) was the best file system under a Linux environment. At the time I didn't know about ZFS - which I think would now be the better choice (features like copy-on-write, CRC checks on reading and writing etc). As for database servers. We tried many, and the Firebird DB Server recovered without a single error in all our tests. Firebird is very well supported on Windows, Linux, UNIX, FreeBSD, AIX and OSX. All our company products now run with the Firebird DB. Oh, and Firebird is free and open source too - another massive benefit. Regards, Graeme