How to recover corrupt database in PocketPC

This case is for DB using Microsoft SQL Server that is put in PocketPC. The crashes of the application can damage the DB (in case the application crash with the DB open). User will realize the DB is corrupt when he try to open the application again and the application crash in the log in window. The message will be ‘Unspecified error \program files\PATH\DB.sdf’ this file is the DB and the application can’t open.
This error is dangerous, about 15% of the DB with this problem is unrecoverable. To fix this error we connect the PocketPC to the server via ActiveSync. Once is connected we open SQL Server and try to open the DB in the HHU. SQL Server will show us three different messages .
1.    This file you’re trying to open is not a correct file format or the DB is corrupt. Do you like to fix it?
That’s good  means we can fix the DB. After clicking ‘yes’ in seconds SQL manage to open the DB. Now we can close SQL, disconnect the HHU from the PC and open the application again.
2.    The file can not be open SQL has problems with the install components of NET CF and/or SQL mobile …
Also we can recover the DB in this case, but not from the HHU. We should copy the DB in the PC. Once we have in the PC we follow the same procedure. After fixing we’ll copy again to the HHU. I’m not sure if after this we can open the application again. If can not, we should reinstall all the modules again as we did in case b.
3.    Unspecified error.
This error is the unrecoverable 15% by now.

Popularity: 32% [?]