Advertisement
Guest User

Untitled

a guest
Jul 16th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. --query by Jack Vamvas - any suspect database?
  2. SELECT DB_NAME(database_id),[file_id],page_id,
  3. CASE event_type
  4. WHEN 1 THEN '823 or 824 or Torn Page'
  5. WHEN 2 THEN 'Bad Checksum'
  6. WHEN 3 THEN 'Torn Page'
  7. WHEN 4 THEN 'Restored'
  8. WHEN 5 THEN 'Repaired (DBCC)'
  9. WHEN 7 THEN 'Deallocated (DBCC)'
  10. END,
  11. error_count,
  12. last_update_date
  13. FROM msdb..suspect_pages
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement