SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

maximus_vj
Yak Posting Veteran

88 Posts

Posted - 09/22/2006 :  12:39:08  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
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  
 New 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.14 seconds. Powered By: Snitz Forums 2000