SQL Server 2008 R2 Express Database Size Limit increased from 4GB to10 GB

I had recently posted about SQL Server 2008 R2 RTM Released.

Well the excitement does not stop here. I was glad to read this official announcement by Microsoft which said that they increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB

The 10 GB size limit also applies to SQL Server 2008 R2 Express with Tools and SQL Server 2008 R2 Express with Advanced Services. The CPU and RAM limits remain the same i.e. 1 CPU and 1 GB of RAM.

Note: In case, you missed it out, SQL Server 2008 R2 Express was also released shortly after the SQL Server 2008 R2 RTM. Here are some important download links:

Microsoft SQL Server 2008 R2 Express
For X86 For X64

Microsoft SQL Server 2008 R2 Express with Tools
For X86 For X64

Microsoft SQL Server 2008 R2 Express with Advanced Services
For X86 For X64

Microsoft SQL Server 2008 R2 Management Studio Express
For X86 For X64

Read more over here ‘Installing SQL Server 2008 R2 Express’


About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

1 comment:

Anonymous said...

That is certainly good news. I have a question though, is the 10Gb size limit for the total of databases created in SQL, or is it per database, meaning that no one database can be bigger then 10Gb?

Also, lets say you start off with a database size of 7Gb and over time it grows to 10Gb+, what happens then?

Thank you and regards, Jurgen.