|
maximus_vj
Yak Posting Veteran
88 Posts |
 Posted - 09/22/2006 : 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
Flowing Fount of Yak Knowledge
USA
1837 Posts |
Posted - 09/22/2006 : 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. |
 |
|
Available File Space 0MB
