Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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