Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Available File Space 0MB
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

88 Posts

Posted - 09/22/2006 :  12:39:08  Show Profile  Reply with Quote

On my Production DB Servers, I have a database that says Available FIle Space as 0 MB. (When I go to Enterprise Manager and Right Click on Database and go to properties)

That database is set to Auto Grow by 20% with Unrestricted File Growth.

But the Database doesn't seem to grow, the available file space always says 0MB.

Data File size is 3 GB and I have 140 GB of free space.

How do I fix it?
Is it a good idea to manually increase the file size?
How long this can take?


Flowing Fount of Yak Knowledge

1837 Posts

Posted - 09/22/2006 :  12:54:49  Show Profile  Reply with Quote
Database space is allocated in pages and new data can be written into existing pages. So when the available space is 0 it simply means that there are no more unallocated pages in the database files, but there may still be plenty of space in the allocated pages.

When a new page needs to be allocated the file/s will grow.

You can see the numbers that EM uses by executing the sp_spaceused stored procedure, take a look at it in Books Online for more info.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000