SQL Express database limit

recently i noticed on a page that the database limit of SQl express was extended.

First of all: what is SQL express. It’s the free version of Microsoft’s SQL server.
because it’s free, it’s (ofcourse) limited. One of these limitations is the maximum database size.

this was always : 4 Gb.
But , as of version 2008R2 (express) this limitation is extended to 10 GB.

Although SharePoint comes OOTB with SQL express 2008 (without the R2), you can cheat during installation. That way you can have a larger database, but still use the free version of SQL. Install SQL 2008R2 express BEFORE installing SharePoint and install it using an Named Instance.

I already showed how this can be accomplished using the full SQL version here.

For more information about SQL express, take a look at the following URL’s

general info about SQL express 2008R2: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Limitation or differences between the versions of SQL 2008 R2 (including the 10 Gb db limit):http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx

Leave a Reply

Your email address will not be published. Required fields are marked *