Databases
StackOverflow2013
Postsdbo
POresolving corruption in SQL Server Compact Edition database files
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POresolving corruption in SQL Server Compact Edition database files
    primarykey
    data
    text
    <p>This is not a query. Its a summary of our solution to get around the problem of corruption in SQL Compact Database files with (almost) definite success. SQLCE Corruption is a very common problem. We've received tremendous help from earlier posts in StackOverflow, and hence this post.</p> <p>Our product is a 3-tier architecture with the server running as a Windows Service connected to Rich Clients through .Net Remoting. Our product uses SQLCE since 2006. We have moved from v3.1, to v3.5 and now v4.0. We've a custom OR-Mapping tool for some very specific requirements. We've faced limited problems with v3.1, we've faced more with v3.5 and v4.0.</p> <p>Initially with v3.5, we implemented <code>SqlCeEngine.Repair</code>. But it only drops the corrupted data, and tries to recreate a stable db. We found that Foreign Keys of affected tables went missing. We had to do away with this immediately. We started notifying users about db corruption, and restore the last backup. This only provided a temporary relief; the problem of corruptions still stood.</p> <p>This year, we adopted v4.0. However, our application also introduced several new features which tremendously increased the number of database calls. v4.0 began well, but started giving problems when the software usage increased. Corruptions happening while the application was running caused neither by Windows crashing, abnormal shutdowns or disk issues. The database just corrupted. </p> <p>The next post covers the solution that we devised for this problem:</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USR D
    1. USR D
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POresolving corruption in SQL Server Compact Edition database files
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POresolving corruption in SQL Server Compact Edition database files
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POresolving corruption in SQL Server Compact Edition database files
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan you please describe the problem in more detail, then move the solution down to an answer? Thanks.
      singulars
      1. POresolving corruption in SQL Server Compact Edition database files
      1. USBill the Lizard
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload