Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sasan_vm
Yak Posting Veteran
51 Posts |
 Posted - 2012-05-11 : 07:06:07
|
| HelloSQL Express 2008 r2 released in variety versions:1- Microsoft SQL Server 2008 R2 RTM - Express (basic) [ ver: 10.50.1600.1, Date published: 4/16/2010 ]2- Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services [ ver: 10.50.1600.1, Date published: 4/19/2010 ]3- Microsoft SQL Server 2008 R2 RTM - Express with Management Tools [ ver: 10.50.1600.1, Date published: 4/20/2010 ]....All this versions support 10GB db size ?Regards,sasan. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-05-11 : 07:32:42
|
| Yes, according to documentation on this page: http://technet.microsoft.com/en-us/library/cc645993(v=sql.105).aspx#ScalabilityEdit: For some reason, the link as posted points to the SQL 2012 page. If you copy the URL above and paste into the address bar, you will get to the page I was looking at. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-11 : 12:51:06
|
quote:
Originally posted by sasan_vm
HelloSQL Express 2008 r2 released in variety versions:1- Microsoft SQL Server 2008 R2 RTM - Express (basic) [ ver: 10.50.1600.1, Date published: 4/16/2010 ]2- Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services [ ver: 10.50.1600.1, Date published: 4/19/2010 ]3- Microsoft SQL Server 2008 R2 RTM - Express with Management Tools [ ver: 10.50.1600.1, Date published: 4/20/2010 ]....All this versions support 10GB db size ?Regards,sasan.
Irrespective of what version it is Express will only support not more than 10 GB total database size for a single instance and not more than 4 GB size for each database.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-05-11 : 14:10:50
|
quote:
Originally posted by Sachin.Nand
quote:
Originally posted by sasan_vm
HelloSQL Express 2008 r2 released in variety versions:1- Microsoft SQL Server 2008 R2 RTM - Express (basic) [ ver: 10.50.1600.1, Date published: 4/16/2010 ]2- Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services [ ver: 10.50.1600.1, Date published: 4/19/2010 ]3- Microsoft SQL Server 2008 R2 RTM - Express with Management Tools [ ver: 10.50.1600.1, Date published: 4/20/2010 ]....All this versions support 10GB db size ?Regards,sasan.
Irrespective of what version it is Express will only support not more than 10 GB total database size for a single instance and not more than 4 GB size for each database.After Monday and Tuesday even the calendar says W T F ....
Microsoft increased the limit to 10 GB for SQL 2008 R2 Express. http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-11 : 14:19:36
|
| Didn't knew that it has been increased to 10 GB.Thanks for pointing that out.After Monday and Tuesday even the calendar says W T F .... |
|
|
|
|
|
|
|
|
SQL Express