I have a corrupted database for testing purposes. Is there a way to detect Errors thrown by DBCC checkdb?
Actually I have 1 allocation error and 2 consitency Errors after running checkdb. However, Diagnostic Manager DB State is green
I thought there should be a critical because database integrity is suspect (see http://www.idera.com/help/sqldm/7-5/default.htm#SQLdm/Database Status.htm)
select * from affected table row:SQL Server detected a logical consistency-based I/O error: incorrect checksum…