SHARE
TWEET

Untitled

a guest Jul 16th, 2019 56 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top