SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

itaka19d
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.

tkizer
Almighty SQL Goddess

USA
36645 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.

Tara
Go to Top of Page

itaka19d
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.
Thanks

Best regards

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