dcf977e5_ase_Integrity_Checks_Checklist__Item
[#] 6 [Steps] If you do find corruption in your database you want to take corrective action to eliminate these issues as soon as possible. This can be done by using one of the following options with DBCC CHECKALLOC, DBCC CHECKDB or DBCC CHECKTABLE. REPAIR_FAST - does minor fast repairs on your database without risk of data loss REPAIR_REBUILD - does minor repairs and also rebuilds indexes without risk of data loss REPAIR_ALLOW_DATA_LOSS - this is a time consuming process and can result in some data loss. All of these repair options require the database to be in single user mode, so you will need to have downtime in order to fix the corruption. Look for a future tip on exactly how to do this. [Item] 
Handling Issues
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