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:05:07
|
| 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? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-02 : 13:11:41
|
| Space available is the free space within the data file. So your DB is 4MB in size, with just under 2.7 MB of data in it.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
SQL Server 2008 Express R2