Share your experience

[cyrus]

Is there possibility that when a user runs dbcc checkdb it gives no errors but the database still throwing errors? I faced this recently and could not figure out the reason for the same. If someone could share their experiences faced similarly in this context and the way they resolved it would help me and others facing this problem.

[rachelle]

There are many errors like memory-only corruption that cannot be found by running dbcc checkdb alone. So there is definitely possibility for getting errors even though when a user runs dbcc checkdb it gives no errors but the database still throwing errors. For the process of error checking one must first check the event log file for hardware and other errors. After correcting
these errors CHECKDB can be used for further analysis and error checking.