823

ﾃ

Product

Name

Event ID

823

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

B_HARDERR

Message

Text

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.

uses Windows APIs, such as

ReadFile

,

WriteFile

,

ReadFileScatter

, and

WriteFileGather

, to perform file I/O operations. After SQL Server performs these I/O operations,

it checks for any error conditions associated with these API calls. If the API calls fail with an

operating system (OS) error, SQL Server reports Error 823.

The 823 error message contains the following information:

The database file against which the I/O operation was performed.

The offset within the file where the I/O operation was attempted. This offset is the

physical byte offset from the start of the file. Dividing this number by 8,192 gives you the

ﾉ

Expand table