Best practices to reduce data corruption in SQL Server Compact 3.5

Microsoft Professional Advisory Services is a support option that provides short-term, proactive, consultative support beyond break-fix product maintenance needs. This includes working with the same technician for assistance with issues like product migration, code review, or new program development and is a remote, phone-based support option. This service is typically used for shorter engagements, and is designed for developers and IT professionals who do not require the traditional onsite consulting or sustained account management services that are available from other Microsoft support options.

For additional information on Microsoft Advisory Services, including on how to engage, refer to this Microsoft web page:

http://support.microsoft.com/gp/AdvisoryService (http://support.microsoft.com/gp/AdvisoryService)

When customers run SQL Server Compact 3.5 applications on a Windows Mobile device or on a Windows CE device, they may encounter data corruption issues. This Advisory Services scenario assists customers who are seeking consulting assistance to help reduce these issues.

Customers need assistance with a review of their SQL Server Compact 3.5 applications, platform/device specifications, execution environment and database manipulation to help reduce data corruption and enhance recovery scenarios. This may involve reviewing suspect databases and providing suggestions (best practices) for application enhancements.

Below is a list of self-help resources or this scenario. These resources may also be used by Microsoft Support Engineers during an Advisory Services engagement.

Maintaining Databases (SQL Server Compact) (http://technet.microsoft.com/en-us/library/ms172411(SQL.100).aspx)

Insight into SQL Server Compact database corruptions (http://blogs.msdn.com/b/sqlservercompact/archive/2008/06/25/insight-into-sql-server-compact-database-corruptions.aspx)

FIX: Some rows are deleted when you repair a database by using the Repair method together with the RepairOption.RecoverCorruptedRows option in SQL Server 2005 Compact Edition and in SQL Server Compact 3.5 (http://support.microsoft.com/kb/967963)

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use (http://go.microsoft.com/fwlink/?LinkId=151500) for other considerations.