SQL Server 2008 R2 Express Database Size Limit Increased to 10GB

Great news for SQL Server Express users today!

We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB.

You can try it out today – just go to SQL Server 2008 R2 Download Page and select “SQL Server 2008 R2 Express” from the menu on the left side of the page:

https://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx

 

FAQ

Is the database size limit increased in all editions of SQL Server 2008 R2 Express?

Yes, SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services will allow 10GB databases as well.

What about CPU and memory limits? Are any other limits changed in SQL Server 2008 R2 Express?

No, the database size limit is the only limit we updated in SQL Server 2008 R2 Express.  SQL Server 2008 R2 Express is still limited to 1 CPU and 1 GB or RAM.

Was the database size limit changed for previous versions of SQL Server Express?

No, the database size limit in previous versions of SQL Server Express (including SQL Server 2005 Express and SQL Server 2008 Express) stays unchanged at 4GB.

 

- Krzysztof Kozielczyk, Program Manager for SQL Server Express