Solved

Space Used in SQL 2008 R2 Express

Posted on 2013-06-03
4
310 Views
Last Modified: 2013-06-03
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
Comment
Question by:APD_Toronto
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39216709
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39216715
In other words if you increased the size allocated to this database to say 100MB the amount unalllocated would increase proportionally.
0
 

Author Comment

by:APD_Toronto
ID: 39216744
Any downside if I increase the size allocation to 10GB?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 39216892
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is this datetime? 1 27
Linked Server - SP with Param to VIew 7 22
Need to trim my database size 9 20
SQL Query Across Multiple Tables - Help 5 17
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question