Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1781

Re: power loss DB corruption

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

power loss DB corruption Hendrik van der Heijden <hvdh@gmx.de> - 2014-04-25 09:43 +0200
  Re: power loss DB corruption Erland Sommarskog <esquel@sommarskog.se> - 2014-04-25 12:24 +0200
    Re: power loss DB corruption bradbury9 <ray.bradbury9@gmail.com> - 2014-04-25 04:42 -0700
      Re: power loss DB corruption Erland Sommarskog <esquel@sommarskog.se> - 2014-04-25 18:16 +0200
        Re: power loss DB corruption bradbury9 <ray.bradbury9@gmail.com> - 2014-04-27 09:08 -0700
  Re: power loss DB corruption rja.carnegie@gmail.com - 2014-04-25 06:54 -0700
  Re: power loss DB corruption Graeme Geldenhuys <graemeg@example.net> - 2014-07-02 22:28 +0100

csiph-web