Space Used in SQL 2008 R2 Express

Hello Experts,

I am using  SQL 2008 R2 Express in a small office environment and I am trying to determine if I am not approaching the disk space limit posed by  SQL 2008 R2 Express as I know this particular version is not unlimited.

I thought the limit was 1 GB, could some one confirm this ?

If my assumption correct, then by the attached, I guess I am using about 90 MB, but why is my "Unused" (pink) graph section is so small?
Picture1.jpg
APD TorontoAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Anthony PerkinsConnect With a Mentor Commented:
It should not be a problem.  You may actually be able to increase it to more than 10 GB, if I recall correctly what matters is the amount used and not the amount allocated.
0
 
Anthony PerkinsCommented:
You need to focus on the green portion not the pink.  And SQL Server 2008-R2 Express Edition supports 10GB so you are a long way off...
0
 
Anthony PerkinsCommented:
In other words if you increased the size allocated to this database to say 100MB the amount unalllocated would increase proportionally.
0
 
APD TorontoAuthor Commented:
Any downside if I increase the size allocation to 10GB?
0
All Courses

From novice to tech pro — start learning today.