Database Repair Constants (SQLDMO_DBCC_REPAIR_TYPE)

SQL-DMO

SQL-DMO

Database Repair Constants (SQLDMO_DBCC_REPAIR_TYPE)

Database repair constants control behavior of the CheckTables and CheckAllocations methods of the Database object.

Constant Value Description
SQLDMORepair_Allow_DataLoss 3 Attempt all database repair regardless of the possibility of data loss. For example, delete corrupted text objects.
SQLDMORepair_Fast 1 Attempt database repair tasks that do not incur data loss.
SQLDMORepair_None 0 Do not attempt database repair on database inconsistencies encountered.
SQLDMORepair_Rebuild 2 Attempt database repair tasks that do not incur data loss. Rebuild indexes on successful database repair.

See Also

CheckAllocations Method

CheckTables Method