Архив за день: 02.06.2011

Select DB_NAME(database_id)
file_id, 'Error case' = CASE event_type 
WHEN 1 THEN '823 or 824 or Torn Page'
WHEN 2 THEN 'Bad Checksum'
WHEN 3 THEN 'Torn Page'
WHEN 4 THEN 'Restored'
WHEN 5 THEN 'Repaired (DBCC)'
WHEN 7 THEN 'Deallocated (DBCC)'
END,
page_id,
error_count,
last_update_date,
PageType = Case
When page_id - 1 % 8088 = 0 Then 'Is PFS Page'
When page_id - 2 % 511232 = 0 Then 'Is GAM Page'
When page_id - 3 % 511232 = 0 Then 'Is SGAM Page'
When page_id BETWEEN 0 and 9 Then 'Is boot Page'
Else 'Is Not PFS, GAM, or SGAM page' 
End
From msdb..suspect_pages
June 2011
M T W T F S S
« May   Jul »
 12345
6789101112
13141516171819
20212223242526
27282930