824

Product

name

Event ID

824

Event

Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

B_HARDSSERR

Message

Text

detected a logical consistency-based I/O error: %ls. It occurred during a

%S_MSG of page %S_PGID in database ID %d at offset %#016I64x in file ‘%ls’. Additional

messages in the SQL Server error log or operating system error log may provide more

detail. This is a severe 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

https://go.microsoft.com/fwlink/?linkid=2252374.

You might encounter the following error message in the SQL Server error log or the Windows

Application event log if a logical consistency check fails after reading or writing a database

page:

Output

ﾉ

Expand table

2022-11-02 15:46:42.90 spid51 Error: 824, Severity: 24, State: 2.
2022-11-02 15:46:42.90 spid51 SQL Server detected a logical consistency-based
I/O error: incorrect pageid (expected 1:43686; actual 0:0). It occurred during a read of page (1:43686) in database ID 23 at offset 0x0000001554c000 in file
'H:\MSSQL16.MSSQLSERVER\MSSQL\DATA\my_db.mdf'. Additional messages in the SQL
Server error log or operating system error log may provide more detail. This is a