Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 | |
|---|---|---|
| AllowDataLoss | Tries to repair all reported errors. These repairs can cause some data loss. | |
| Fast | Maintains syntax for backward compatibility only. No repair is performed. | |
| None | 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. |
Remarks
The RepairType enumeration class is served by the CheckTables method and the CheckAllocations method.