dcf977e5_ase_Integrity_Checks_Checklist__Item
[#] 2 [Steps] There are basically four different commands that can be run to check various levels of consistency within your database. The four options are listed below with a short description of each as listed in SQL Server Books Online. DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database DBCC CHECKCATALOG Checks for catalog consistency within the specified database. DBCC CHECKDB - Checks for catalog consistency within the specified database. DBCC CHECKTABLE Checks the integrity of all the pages and structures that make up the table or indexed view. The most widely run option is DBCC CHECKDB because it checks the entire database, but the other options are helpful for quicker spot checking. In addition, all of these commands have additional options that can be selected to check for only a portion of the data and also for repairing any corruption that has been found. [Item] 
Understand Commands
D e t e r m i n e W h a t i s N e e d e d
U n d e r s t a n d C o m m a n d s
R u n n i n g
S c h e d u l i n g
R e v i e w i n g O u t p u t
H a n d l i n g I s s u e s
SQL Server Database Integrity Checks Checklist
Item