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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Available File Space 0MB

Author  Topic 

maximus_vj
Yak Posting Veteran

88 Posts

Posted - 2006-09-22 : 12:39:08
Hello,

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?

Thanks
maximus

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-09-22 : 12:54:49
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
   

- Advertisement -