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
'Bildirim
Public Enumeration RepairType
public enum RepairType
public enum class RepairType
public enum 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.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.