May 06, 2010

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’


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

1 Response to "SQL Server 2008 R2 Express Database Size Limit increased from 4GB to10 GB"
  1. Anonymous said...
    February 12, 2011 at 3:39 AM

    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.

 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions