Home Dashboard Directory Help
Search

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: 

Closed
 as Fixed Help for as Fixed


0
0
Sign in
to vote
Type: Bug
ID: 445456
Opened: 5/8/2009 10:54:46 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

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)
myEngine.Upgrade(ConnectionString)
Where:
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;"
Note:
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?
Details
Sign in to post a comment.
Posted by Microsoft on 9/21/2009 at 12:00 AM
Hi,
This issue has been fixed as a hotfix. Please review the following KB article to know the details of the fix.
http://support.microsoft.com/kb/971027/
Thanks and regards,
Himadri
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.

Regards

Ambrish
Sign in to post a workaround.