November 17, 2003 at 1:50 pm
Hi, All
I have a q for U.
One of my database shows 0MB space available in the General tab even though I have a plenty of space abvailale?
Database is 100GB and set to 10% growth with unlimited. I have a 90GB available for that drive?
Any idea?
Thx in advance.
Jay
November 17, 2003 at 2:37 pm
Hey Jay,
What happens when you try to insert more data? Do you receive an error? Does the database grow in size?
-Dan B
November 17, 2003 at 3:43 pm
Nothing.. That works great. I mean SQL server.
Jay
November 17, 2003 at 4:20 pm
Do you have the AutoShrink option turned on?
-Dan B
November 18, 2003 at 7:27 am
No.. but Auto Update Statistics and Auto creating statistics are turned on.
Jay
November 18, 2003 at 7:35 am
My databases do this sometimes. If you run DBCC UPDATEUSAGE in QA for the database then it should correct itself.
I know it doesn't answer your question about why but it fixes the numbers.
Jeremy
November 18, 2003 at 8:20 am
Thx..Jeremy..
That fixes 0MB problem...
Right.. That gives me more q why that happens..
Jay
November 18, 2003 at 9:01 pm
Just to add, you can run sp_spaceused with the updateusage command to get the same effect
sp_spaceused @updateusage = 'TRUE'
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
December 15, 2003 at 12:20 pm
Was this database created fresh? Or was it detached/attached or backed up / restored.
-Carlos
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply