Solved

SQL SERVER 2000 Database space available

Posted on 2003-12-04
3
2,161 Views
Last Modified: 2008-02-28
I recently found that one of the SQL Server databases was showing 0.00 MB space available, so I increased the size of the data files within the primary group and have got a lot of spare disk space but enterprise manager still show 0.00 MB free space. However if I select the 'Taskpad' option from the 'view' menu from Enterprise Manager, it shows me that I have got a lot of free space in the data files. My question is why is Enterprise Manager still showing 0.00 MB.

Appreciate all comments.
Thanks in advance.

Best Regards,
Atif.
0
Comment
Question by:atifaminuk
3 Comments
 
LVL 3

Expert Comment

by:kathmacmahon
ID: 9874430
What is your licensing for SQL Server?  How big is the database?
0
 

Author Comment

by:atifaminuk
ID: 9874556
Licensing is per processor and the database is about 4.5 GB.
0
 

Accepted Solution

by:
stefanvenken earned 125 total points
ID: 9874630
If I'm not mistaking the 'free space' the database properties mentions is the free space of the current database-size. If you however like probably most people have set the database to grow by percent or by x mb, it simply means that the database will grow soon. But you probably have set auto-growth to a 1 mb a time...

So the database mentions : 0 mb free, if you change the value of the growth of your log files for instance to grow width 100mb a time, it will (probably) alter to 96 mb, 94mb, ... till 0 and then jump over again.

Normally this isn't something you should worry about, if you know you have enough disk space left.

kind regards Stefan
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

708 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

15 Experts available now in Live!

Get 1:1 Help Now