SQL Server Compact - Error The database file is larger than the configured maximum database size

Arthur_Kater · March 2020

While trying to connect to a 1GB SQL Server Compact (*.sdf) database, I get the error: The database file is larger than the configured maximum database size. This setting takes effect on the first concurrent database connection only.

I have added the additional connection string parameter "Max Database Size=4096", which doesn't solve the problem.
Anyone an idea?

JoeAlbahari · April 2020

There's an option in the connection dialog to specify the maximum database size. Set that to 4091 and it should allow for the largest database that CE can support.

Arthur_Kater · April 2020

Thanks. That worked.

sabuncu · April 2020

LOL - 4091! They had to set aside 5 MB for their own use.

SQL Server Compact - Error The database file is larger than the configured maximum database size

Comments