Database Corruption SQL Errors – 823, 824, 825

These alerts are focussed on successful access(IO) to the hard drives that SQL Server is using. If there are  any errors when reading or writing to the drives then one of these errors will be returned. Having the alerts on these errors means that any IO issues will be brought to the DBAs attention well before a disk actually fails.

SELECT  m.[message_id] ,
        m.[severity] ,
        m.[is_event_logged] 
FROM    sys.messages AS m
WHERE   language_id = 1033
        AND m.[message_id] IN ( 823, 824, 825 )
AND is_event_logged = 1 
ORDER BY severity ,
        m.[message_id]

Sources:

Alerts are good, aren’t they?