dcf977e5_ase_Integrity_Checks_Checklist__Item
[#] 3 [Steps] Ad Hoc - At its most basic level all of these commands can be run from a query window and can be run interactively against a database. When running the commands to check for any issues they can be issued while users are still accessing the database, but as with most maintenance operations it is always good to run them during off hours. Maintenance Plans - as mentioned above you can setup maintenance plans in both SQL Server 2000 and SQL Server 2005 to run the DBCC CHECKDB command. This is the only option you have with the base maintenance plans options. Custom Jobs - you can create your own SQL Server Agent jobs to run the selected command against the entire database or individual objects. This option gives you the most flexibility as well as allows you to schedule execution during off hours. SQLMAINT utility - this is an external executable that has options to run the consistency checks. With this tool you can run CHECKALLOC, CHECKCATALOG and CHECKDB. You do not have the ability to check an individual table. [Item] 
Running
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