SqlCeEngine.Repair Method
.NET Framework 3.0
Repairs a corrupted database.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
'Declaration Public Sub Repair ( _ connectionString As String, _ options As RepairOption _ ) 'Usage Dim instance As SqlCeEngine Dim connectionString As String Dim options As RepairOption instance.Repair(connectionString, options)
public void Repair ( String connectionString, RepairOption options )
public function Repair ( connectionString : String, options : RepairOption )
Not applicable.
Parameters
- connectionString
The local connection string to the database.
- options
The RepairOption to use when repairing the database.
If the repair method is invoked by using the RepairOption's DeleteCorruptedRows value, all corrupted pages are discarded from the database. This may result in significant data loss, but the data recovered using this option should be free from corruption.
If the repair method is invoked by 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.
Community Additions
ADD
Show: