Export (0) Print
Expand All
Expand Minimize

RepairOption Enumeration

When passed to the Repair method, RepairOption specifies the type of database repair to perform.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

public enum RepairOption
public enum RepairOption
public enum RepairOption

Member nameDescription
DeleteCorruptedRowsDeletes all corrupted rows without attempting to fix them.
RecoverAllOrFail 
RecoverAllPossibleRows 
RecoverCorruptedRows NOTE: This field is now obsolete.

Attempts to fix all corrupted rows rather than deleting them.

When using the RepairOption's DeleteCorruptedRows value, all corrupted pages are discarded from the database. This may result in significant data loss, but the data that is recovered using this option will be free from corruption.

When using the RepairOption's RecoverCorruptedRows value, the database will attempt to read data from the corrupted pages. This potentially results in more data being recovered, but this option does not guarantee that the data recovered will be free of corruption.


Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0

Show:
© 2014 Microsoft