SQL SERVER 2000 Database space available

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.

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

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.