Solved

SQL SERVER 2000 Database space available

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

911 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

19 Experts available now in Live!

Get 1:1 Help Now