| title | suspect_pages (Transact-SQL) | ||
|---|---|---|---|
| description | suspect_pages (Transact-SQL) | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.date | 06/10/2016 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Contains one row per page that failed with a minor 823 error or an 824 error. Pages are listed in this table because they are suspected of being bad, but they might actually be fine. When a suspect page is repaired, its status is updated in the event_type column.
The following table, which has a limit of 1,000 rows, is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| database_id | int | ID of the database to which this page applies. |
| file_id | int | ID of the file in 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 in a file. |
| event_type | int | The type of error; one of: 1 = An 823 error that causes a suspect page (such as a disk error) or an 824 error other than a bad checksum or a torn page (such as a bad page ID). 2 = Bad checksum. 3 = Torn page. 4 = Restored (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. |
Anyone with access to msdb can read the data in the suspect_pages table. Anyone with UPDATE permission on the suspect_pages table can update its records. Members the db_owner fixed database role on msdb or the sysadmin fixed server role can insert, update, and delete records.
Restore Pages (SQL Server)
Database Suspect Data Page Event Class
System Tables (Transact-SQL)
Manage the suspect_pages Table (SQL Server)