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 |
|
cubesd
Starting Member
2 Posts |
 Posted - 2011-04-02 : 06:07:19
|
| Hi peeps,I am currently utilising Microsoft SQL 2008 R2 Express. Hopefully by next week I'll have 2008 Enterprise but nevertheless, the development needs to continue.So, I have created a database with a few tables (20 or so), most columns are of the varchar(MAX) type. Everything is working super! However, when I use Management Studio, the system reports that the database size is 4MB (which is correct) but the Space Available shows 1.34MB.Why does it show this? Does it mean that in 1.34MB my database will reach its limit? Even if you recreate the database, this happens. Re-installation doesn't help either. What happened to the 10GB size limit? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-04-05 : 07:42:43
|
| Express database size limit is 10GB (http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx)Actually database aquires space in chunks, Space Available means (Initial Space Aquired by Dababase - Used Space), When initial space will be fully aquired and it need more, it will expend itself according to given prameter of AutoGrowth (default criteria is 1MB for mdf and 10% for ldf files)--------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
SQL Express Size Reporting