compact sqlce database

Qiuwei

Hi, there;

I got a SqlCe2.0 database here called JOB.sdf, size is 260K. When I tried to compact it, it took very long and that JOB.sdf.tmp was created with 27.7M!!!, I can still open table in the database, but I found that there is some invalid data (unreadable square boxes). It looks like database was corrupted. My application gave error:

Error Code: 80040E14
Message : The OLE DB Execute method failed. The SQL statement is not valid. [,,,SQL statement,,]
Minor Err.: 28560
Source : Microsoft SQL Server 2000 Windows CE Edition
Error Code: 80040E14
Message : Line 1: Incorrect syntax near '















a c €e¡¯ i¡À¡¯e Ra a! e¡é e a3 '.
Minor Err.: 170
Source : Microsoft OLE DB Provider for SQL Server
Error Code: 80040E14
Message : Unclosed quotation mark before the character string '















a c €e¡¯ i¡À¡¯e Ra a! e¡é e a3 '.
Minor Err.: 105
Source : Microsoft OLE DB Provider for SQL Server</E>

Note: "















" is displayed as "SOHSOH....." with black background.

Apart from compacting database, is there manual job or tool we can do/use to fix a corrupted database caused by power failure (e.x: all data saved successfully before power failure)

Thanks

petr.antos

HI,

have you tried to use newer SQLCE engine with existing corrupted database

Although I had never tried it yet, I think that when you try "Verify" and "Repair"

features of SQLCE, you can safely survive most of your database. Go and

download SQL CE 3.1 desktop engine and tools, its even good to work with it :-)

hope it helps,

Petr

Qiuwei

Thanks.

How can get the newer SQLCE engine Can that be run at desktop without a device

I have quite a bit corrupted databases whih is a disaster now!

petr.antos

Yes, you can download all engines withing SDK from here:

http://www.microsoft.com/sql/editions/compact/default.mspx

resp.

http://www.microsoft.com/downloads/details.aspx FamilyId=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en

may be other tools from this web may help you too.

Without VS2005, you can manage database through

free SQLServer Management Studio Express

http://www.microsoft.com/downloads/details.aspx FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

I dont know if is possible to verify/repair from this gui app, but at least you can

build small C# or VB.NET desktop project against new engine, using your corrupted database

and try verify/repair methods.

Petr

petr.antos

:-( excuse me, SQLSerer Management Studio must be full, not only Express !!!

This is very big download, so it may dissappoint you.

BTW, best is to do small project itself and use code :-)

Petr

Qiuwei

Thank you. I will give it a try.