Pages in an SQL database that are torn or suspect are accomulated in a table and can be queried with
SELECT * FROM [msdb].[dbo].[suspect_pages]
Columns are database_id, file_id, page_id, event_type, error_count, and last_update_date
Consider Select count(*) … to get an overview.
When SQL Server tries to read a page into memory (during a query, following DBCC checkDB operation or a backup) and can’t, it issues a 823 or 824 error. It probably gets logged (?) but should also be posted to the suspect_pages table in MSDB.