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)
Syntax
'Declaration
Public Enumeration RepairType
'Usage
Dim instance As RepairType
public enum RepairType
public enum class RepairType
type RepairType
public enum RepairType
Members
| Member name | Description | |
|---|---|---|
| None | No repair is performed. | |
| Fast | Maintains syntax for backward compatibility only. No repair is performed. | |
| Rebuild | 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. | |
| AllowDataLoss | Tries to repair all reported errors. These repairs can cause some data loss. |
Remarks
The RepairType enumeration class is served by the CheckTables method and the CheckAllocations method.