REPAIROPTION

REPAIROPTION specifies the type of database repair to perform.

Members

Member name

Value

Description

DeleteCorruptedRows

0

SQL Server Compact 4.0 deletes all corrupted rows.

RecoverCorruptedRows

1

Deprecated. Please use RecoverAllPossibleRows. (SQL Server Compact 4.0 tries to recover any corrupted rows.)

RecoverAllPossibleRows

1

SQL Server Compact 4.0 tries to recover all the corrupted rows, instead of deleting them.

RecoverAllOrFail

2

SQL Server Compact 4.0 tries to recover data only if there is no data loss. In condition of data loss the operation is stopped.

See Also

Tasks

How to: Verify and Repair a Database (Programmatically)

Reference

Repair Method (SQL Server Compact)

Concepts

Using and Maintaining Databases (SQL Server Compact)