TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Check Integrity of Database with Suspect Pages

 

Applies To: SQL Server 2016

This rule checks for user databases that have the database status set to suspect. When the SQL Server Database Engine reads a database page that contains an 824 error, the page is considered suspect, its page ID is recorded in the suspect_pages table in msdb, and the database that contains the page is set to suspect.

Error 824 indicates that a logical consistency error was detected during a read operation. This error frequently indicates data corruption caused by a faulty I/O subsystem component. This is a severe error condition that threatens database integrity and must be corrected immediately.

  • Review the SQL Server error log for the details of the 824 error for this database.

  • Complete a full database consistency check (DBCC CHECKDB).

  • Implement the user actions that are defined in MSSQLSERVER_824.

Manage the suspect_pages Table (SQL Server)

Community Additions

ADD
Show:
© 2016 Microsoft