Issue
ACCTrace and Windows error log show multiple DBFaultDetection, SQLSTATE ERROR CODE: S1000, ERROR MESSAGE: [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Fatal error 823 occurred
Environment
CyberStation
Cause
Device (disk) error.
Resolution
Recommended course of action from Microsoft:
Error 823
Severity Level 24
Message Text
I/O error %ls detected during %S_MSG of %S_BUF.
Explanation
Microsoft SQL Server encountered an I/O error on a read or write request made to a device. This error usually indicates disk problems. The parameters in the error message refer to internal structures and don't often help determine which device is involved. However, additional kernel messages in the error log, recorded before error 823, should indicate which device is involved.
Action
Check the accessibility and condition of the device in question. After you have identified and corrected the problem, execute DBCC CHECKDB to ensure that no other damage was caused by the bad device. For information about using DBCC CHECKDB, see "DBCC CHECKDB" in Microsoft SQL Server Transact-SQL and Utilities Reference.
Important
If executing DBCC CHECKDB with one of the repair clauses does not correct the index problem or if you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact your primary support provider. In addition, run hardware diagnostics and correct any problems
