Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.datemas.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Hendrik van der Heijden Newsgroups: comp.databases.ms-sqlserver Subject: power loss DB corruption Date: Fri, 25 Apr 2014 09:43:19 +0200 Organization: solani.org Lines: 27 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Trace: solani.org 1398411802 6139 eJwFwQkRADAIAzBL/B1yBrf6l7AkvbQWUVmRTPbzw3YtwQ3jLunYQ/Vp5tzXkJE1wDZE4wMgcBEH (25 Apr 2014 07:43:22 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Fri, 25 Apr 2014 07:43:22 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 X-User-ID: eJwFwYEBwCAIA7CXYNCK54jU/09YgqDzriSYeHh1AnvCnyv2/ToZHKhahTHKvrNOcY9WJay5TAPAmwqEfkg2FRQ= Cancel-Lock: sha1:JH8Fj0Ct7Vxpet4Tcilw5U9A7SY= X-NNTP-Posting-Host: eJwFwQkBACAIA8BKgmNCHOXpH8E72xTmAY2wsakEY5YjFbVleUg+JiDu3U8xF3Erpq0UxAcX7hEN Xref: csiph.com comp.databases.ms-sqlserver:1739 Hi everyone, 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. I have a standard consumer PC (single SATA drive on Intel Chipset Controller) running Windows 7 and MS SQL Server 2012 Express. When I load the database with transactions and pull the PC power cord, due to ACID compliance, I expect to get no data loss on reportedly completed transactions. However, on SQL Server 2012 very often the database is corrupt afterwards and cannot be used anymore. I tried to disable HDD write caching, but it didn't improve things. On SQL Server 2008, the problem occurred less likely. ** Can somepoint point me to documentation stating whether MSSQL ** supports ACID (especially the D) compliance on consumer hardware ** and what needs to be configured? PostgreSQL, InnoDB and others support this as they can be configured to use fsync after each transaction. Does Microsoft also offer this? Hendrik vdH