SQL Server Performance Forum – Threads Archive

What are some possible causes for data corruption?

If Begin Transaction and Commit Transaction statements are used, what are some possible causes for data corruption in additional to programming errors? I’m looking for causes related to hardware and/or SQL Server settings. Thanks.

Trick Question. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> There are probably millions if we could think of them all.

Code:

<br />Hardware Failures:<br /> Power failure with no proper UPS on a disk array with write cache.  Had this one happen before because of an idiot manager.<br /> Improper pathing between host/array.  <br /><br />SQL Server Settings:<br /> ????  Not sure about this one.  I'm sure someone can think of a couple examples.<br /><br />Programming Logic: (the most common)<br /> Your BEGIN and COMMIT statements don't do you any good if you haven't properly capture the data flow process inside the commit.<br /><br />Are you looking for something a little more specific?<br /><br />MeanOldDBA<br />[email protected]<br /><br />When life gives you a lemon, fire the DBA.

derrickleggett, I’m interested in understanding more about the caching. Based on MS articles that I found, there are 2 types of caching related to data corruption: Hard Disk Controller Caching and Disk Drive Caching. I guess the one you mentioned is Hard Disk Controller Caching. I hope you can explain more about them or point me to some good articles in addition to the following MS articles: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B230785&Product=sql2k</a> http://support.microsoft.com/kb/86903/EN-US/</a> http://support.microsoft.com/kb/46091/EN-US/</a> http://support.microsoft.com/kb/234656/EN-US</a> If there is a webcast, it will be even better.[<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />]

Do a search in the Google groups on Error 823 and/or Paul Randal. Paul Randal is Dev lead of the SQL Server Storage Engine and usually responds to such things when nobody else knows. ———————–
–Frank
http://www.insidesql.de
———————–

]]>