Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

RepairType Enumeration


The RepairType enumeration contains values that are used to specify the type of repair mode used by the database consistency check (DBCC) functions.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public enum RepairType

Member nameDescription

Tries to repair all reported errors. These repairs can cause some data loss.


Maintains syntax for backward compatibility only. No repair is performed.


No repair is performed.


Performs repairs that have no possibility of data loss. This can include quick repairs, such as repairing missing rows in non-clustered indexes, and more time-consuming repairs, such as rebuilding an index. REPAIR does not repair errors involving FILESTREAM data.

The RepairType enumeration class is served by the CheckTables method and the CheckAllocations method.

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft