Share via


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

System Tables (Transact-SQL)

Other Resources

Understanding and Managing the suspect_pages Table
Pages and Extents

Help and Information

Getting SQL Server 2005 Assistance