suspect_pages (Transact-SQL)
Contains one row per page that failed with an 824 error (with a limit of 1,000 rows). These pages are suspected of being bad but may actually be fine). This table is stored in the msdb database.
A database administrator can insert, update, and delete records from the suspect_pages table.
| Column name | Data type | Description |
|---|---|---|
database_id |
int |
ID of the database to which this page applies. |
file_id |
int |
ID of the file within the database. |
page_id |
bigint |
ID of the suspect page. Every page has a page ID that is a 32-bit value identifying the location of the page in the database. The page_id is the offset into the data file of the 8 KB page. Each page ID is unique within a file. |
event_type |
int |
The type of error, one of: 1 = 824 errors other than a bad checksum or a torn page (for example, a bad page ID) 2 = Bad checksum 3 = Torn page 4 = Restored (The page was restored after it was marked bad.) 5 = Repaired (DBCC repaired the page.) 7 = Deallocated by DBCC |
error_count |
int |
Number of times the error has occurred. |
last_update_date |
datetime |
Date-and-time stamp of the last update. |
See Also
Reference
Other Resources
Understanding and Managing the suspect_pages Table
Pages and Extents