Solved

Space Used in SQL 2008 R2 Express

Posted on 2013-06-03
4
304 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
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now