The operating system returned error %ls to SQL Server during a %S_MSG at offset %#016I64x in file ‘%ls’. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

Details
Product: SQL Server
Event ID: 823
Source: MSSQLServer
Version: 9.0
Component: SQLEngine
Symbolic Name: B_HARDERR
Message: The operating system returned error %ls to SQL Server during a %S_MSG at offset %#016I64x in file ‘%ls’. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
   
Explanation

A Windows read or write request has failed. The error code that is returned by Windows and the corresponding text are inserted into the message. In the read case, SQL Server will have already retried the read request four times. This error is often the result of a hardware error, but may be caused by the device driver. For more information about error 823, see
http://support.microsoft.com/kb/828339http://support.microsoft.com/kb/828339
. For more information about I/O errors, see
Microsoft SQL Server I/O Basics, Chapter 2http://go.microsoft.com/fwlink/?LinkId=69370
.

   
User Action

Check for additional information in the system event log. Contact the hardware manufacturer or Microsoft Customer Services and Support to determine the cause and corrective action. After the hardware error is fixed, restore all databases and run DBCC CHECKDB.

Related:

Leave a Reply