Post reply

dB is oK, but "space available 0.0" shown

  • August 2, 2004 at 6:56 am

    #85140

    (sql server 2000) : I have three data files and three log files.  Max file size on each is 1 gig and increment by 20 meg.  At the present time each log file is under 50mb, and the data files are 890mb, 520mb, 640mb.

    Why is it showing 0.0meg?  It has been this way for a couple days.  I assume this is a reporting issue, the database nets over 10K records in various tables a day, followed by a weekly purge of "not needed rows".

    Any ideas on how to get it to report correctly?

    Do I have a problem and don't know it yet?

     

    thanks,

    Joseph

  • August 2, 2004 at 7:31 am

    #517237

    Have you tried running DBCC UPDATEUSAGE??

    -SQLBill

  • August 2, 2004 at 8:02 am

    #517262

    Thanks, that did the trick!

     

    Joseph

  • August 2, 2004 at 8:27 am

    #517271

    Good call Bill...

     

    fyi.. SQL Server reports space usage from the sysindexes table.  Sometimes SQL Server isn't always able to keep up with the changes and the reporting numbers are out of date.   Personally, I use a script I created to properly indicate usage and growth in all individual datafiles.


    "Keep Your Stick On the Ice" ..Red Green

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply