Solved

SQL SERVER 2000 Database space available

Posted on 2003-12-04
3
2,182 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL clustering failover 8 39
SQL Calculation syntax based on a parameter 2 28
sql server stored procedure parameter 10 20
Need help with another query 10 34
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

679 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