Where is the recovery utility SQL Server Compact?

Question

I used C # System.Data.SqlServerCeversion 3.5.1.0 to create a database file .SDF. When opening a connection after creation, I sometimes get the following error:

The database file may be corrupted. Run the recovery utility to check the database file. [Database Name = \? \ C: \ SomeDatabase.sdf]

Where is the repair utility located? How do we use it?

I searched google and stackoverflow for answers:

• SQL Server Compact Recovery Utility
• SDF Recovery Utility

This MSDN article article talks about this programmatically. Is there a command line method?

Answer 1

#.NET, :

class Program
{
    static void Main(string[] args)
    {
        SqlCeEngine engine = 
             new SqlCeEngine("Data Source = C:\\Users\\SomeUser\\Documents\\SomeDB.sdf");
        if (false == engine.Verify())
        {
            Console.WriteLine("Database is corrupted.");
            try
            {
                engine.Repair(null, RepairOption.DeleteCorruptedRows);
            }
            catch(SqlCeException ex)
            {
                Console.WriteLine(ex.Message);
            }
        }
        Console.WriteLine("Press any key to continue.");
        Console.ReadLine();
    }
}

MSDN. ScriptCs.

Answer 2

sqlcecmd , sqlcecmd.codeplex.com