Use below query to find the torn pages in SQL Server 2005 or later versions.
Suspect_pages table is located in MSDB database.
SELECT db_name(database_id) DatabaseName, file_id, page_id, last_update_date
FROM msdb.dbo.suspect_pages WHERE event_type = 3
The above query result will display torn page and that page located in which file and when torn page issues happened that date will show.
Suspect_pages table is located in MSDB database.
SELECT db_name(database_id) DatabaseName, file_id, page_id, last_update_date
FROM msdb.dbo.suspect_pages WHERE event_type = 3
The above query result will display torn page and that page located in which file and when torn page issues happened that date will show.
