Upgrading from SQL CE v3.1 to v3.5 causes error: "The database file is larger than the configured maximum database size. - by PatMcHargue

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 445456 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 5/8/2009 10:54:46 AM
Access Restriction Public


In VS2008, the following two lines of code are used to upgrade a v3.1 SQLserverCE DataBase to v3.5:

 Dim myEngine As New SqlCeEngine(BackupConnectionString)
   BackupConnectionString = "Data Source=C:\LgCnv.vtprj.BKPv31; Max Database Size=4091;"
   ConnectionString = "Data Source=C:\LgCnv.vtprj; Max Database Size=4091;"
  I also tried:
   BackupConnectionString = "Data Source=C:\LgCnv.vtprj.BKPv31; ssce:Max Database Size=4091;"
   ConnectionString = "Data Source=C:\LgCnv.vtprj; ssce:Max Database Size=4091;"
  Even though the extensions are not SDF, the files are SQLserverCE files. The file size of the v3.1 (source) file is 385MB.  The v3.5 (destination) file grows until it hits 386, and then the error is thrown.
The error returned is:
 "The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only. [ Required Max Database Size (in MB; 0 if unknown) = 386 ]"
I've searched for a solution to this problem, but I can't seem to find what I need.  Does anyone know how this can be done?
Sign in to post a comment.
Posted by Microsoft on 9/21/2009 at 12:00 AM
This issue has been fixed as a hotfix. Please review the following KB article to know the details of the fix.
Thanks and regards,
Posted by Microsoft on 5/18/2009 at 5:07 AM
Thanks for logging the issue. We are analyzing the issue and will revert back with the resolution. If you need an update on the status of resolution please contact us by posting to this Connect bug ID.