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’
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?
ReplyDeleteAlso, 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.