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.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problems with Database available space
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 08/17/2004 :  04:20:04  Show Profile  Reply with Quote
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 - 08/17/2004 :  12:07:51  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 - 08/20/2004 :  01:49:21  Show Profile  Reply with Quote
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
  Previous Topic Topic Next 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.02 seconds. Powered By: Snitz Forums 2000