June 25, 2012 at 4:33 am
I understand that in SQL Server 2008 R2 Express, the previous limit of 4GB is extended to 10GB. Would this higher limit apply to a database transferred from SQL Server 2005 Express?
Nick Walker
June 25, 2012 at 4:57 am
Once you've moved it up to the new version, yes, it will get the new limit. Be sure you set the compatibility level on the database too so that you get all the new functionality.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
June 25, 2012 at 4:59 am
Great - thanks for your help.
Nick Walker
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy