Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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
0
APD Toronto
Asked:
APD Toronto
  • 3
1 Solution
 
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
 
Anthony PerkinsCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now