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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problems with Database available space

Author  Topic 

Starting Member

2 Posts

Posted - 2004-08-17 : 04:20:04
hy everybody,

I have a 12 gb database. It is configured to automaticaly grow in blocks of 250 MB.
The avaible space at the E.M. DB is 0.0 MB. but the HD free space is 13GB.
I've tryed to check the DB wiht the CHECKDATABASE command and all was right.
I've also forced the DB size to 13 GB.
Doing that the avaible space contiunes to 0.0 MB but the allocated space shows 1 GB avaible.
After that I can work for a time until a srink operation is made, which return me to the original situation.

Almighty SQL Goddess

38200 Posts

Posted - 2004-08-17 : 12:07:51
So you do have free space in the MDF file? You can view it with sp_spaceused.

Go to Top of Page

Starting Member

2 Posts

Posted - 2004-08-20 : 01:49:21
I got unallocated space returned in negative value.
But I've used (sp_spaceused @updateusage = true) and then all has functioned correctly.

Best regards

Go to Top of Page

- Advertisement -