June 17, 2009 at 2:54 am
Hi SQL Server Central peeps ...
I have 2 DB's with DB available space ==> 0.00MB issue
Both have 9 user created file groups with 9 data files.
Primary file group ...
Auto Growth by 10 percent and unrestricted growth on all files including log file.
Log file and DB files drives all have 30GIG Plus space available ...
DB size is 6GIGs ...
DB status is normal
Recovery model is SIMPLE
Database Read-Only ==> False
Why is the Space avaialble 0.00Mb's ???
What am I missing here???
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 17, 2009 at 3:33 am
Did you check if your HD is full?
Did you check if your t-log file space is used or just needs to be shrink?
Did you try to shrink t-log files?
Did you check activity monitor for open transactions which might cause not shrinkable t-log files?
June 17, 2009 at 3:33 am
Have you tried running UPDATE USAGE to see if it's just telling you the wrong information?
June 17, 2009 at 3:47 am
BU69 (6/17/2009)
Have you tried running UPDATE USAGE to see if it's just telling you the wrong information?
Hi Guys Thanx ...
Googled the problem and did a DBCC UPDATEUSAGE on the Dev DB 1st ...
It updated most if not all the indexes on the DB and the space available issue is now resolved :-D:-D
Thanx for your responses Peeps ;-);-)
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
June 17, 2009 at 4:13 am
No problem, I run UPDATEUSAGE every night as I get stats for the database sizes etc so need them to be accurate but it's worth running this on a regular basis on all your databases.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply