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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Problems with Database available space
 New Topic  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

38119 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  
 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.05 seconds. Powered By: Snitz Forums 2000