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.
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?Thanksmaximus |
|
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. |
 |
|
|
|
|