CODEWITHSUNDEEP
sql-server-2008filesizemdf
foo0110
foo0110

Reputation: 165

SQL Server 2008 Express Edition file size limitation problem

The SQL Server error I encounter as below:

Could not allocate space for object 'dbo.xxx'.'PK_xxx' in database 'mainDB' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

My question is why the MDF file size is limited to only 4GB while the SQL instance running is SQL Server 2008 Express Edition (which I found it supposed to be 10GB instead).

Upvotes: 3

Views: 10209

Answers (1)

Tom Chantler
Tom Chantler

Reputation: 14931

SQL Server 2008 Express supports 4GB.

SQL Server 2008 R2 Express supports 10GB.

Don't forget that the size limit doesn't include the log files (link for SQL Express 2005, but I couldn't find similar for SQL Express 2008 R2 and I don't think this fact has changed). It also doesn't include FILESTREAM data either, which is nice. There are a few useful comments about this here.

This SQL Server Blog entry announced the size increase.

Upvotes: 5

Related Questions