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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Express Size Reporting

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/
Go to Top of Page
   

- Advertisement -