Problem: How to check the consistency of a SQL Server database.
Solution:
DBCC checkdb WITH no_infomsgs, all_errormsgs;
-
This Command can put overhead on the database.
-
Normally schedule to run at off peak hours.
-
See the database consistency history report by right click the database>select Reports>Select Standard Reports>Select Database Consistency history
Figure 1: Database Consistency History
