Check for suspect pages

SQL Servers keeps record of the corrupted pages it accesses in msdb table dbo.suspect_pages. Note that table only holds 1000 rows. Then again you should not find any records in it whenever querying it!

SELECT d.name AS databaseName,
  mf.name AS [File Name],
  mf.physical_name AS [Physical File Name],
  sp.page_id,
  CASE sp.event_type
    WHEN 1 THEN N'823 or 824 error'
    WHEN 2 THEN N'Bad Checksum'
    WHEN 3 THEN N'Torn Page'
    WHEN 4 THEN N'Restored'
    WHEN 5 THEN N'Repaired'
    WHEN 7 THEN N'Deallocated'
  END AS [Event Type],
  sp.error_count,
  sp.last_update_date
FROM msdb.dbo.suspect_pages AS sp
JOIN sys.databases as d 
ON sp.database_id = d.database_id
JOIN sys.master_files as mf 
ON sp.[file_id] = mf.[file_id]
 AND d.database_id = mf.database_id;