home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,083 of 19,505   
   Graeme Geldenhuys to Hendrik van der Heijden   
   Re: power loss DB corruption   
   02 Jul 14 22:28:43   
   
   From: graemeg@example.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca