Post reply

Space Available 0.0

  • July 9, 2003 at 8:25 am

    #159507

    I don't know what's going on. The application is running fine, but I have not seen a database is staying at 0.0

    I have never seen is a database stay at 0.0.

    There are two datafiles

    a.mdf

    b.ndf

    a.mdf is 1238 meg, 20meg increment max size 2048meg

    b.ndf is 638 meg, 20meg increment max size 2048meg

    There is enough physical disk space. Am I worring for nothing? I do not see errors in the error log.

    Could it be a lack of activity and the file has not needed to expand for a period of hours?

    Joseph

  • July 9, 2003 at 9:29 am

    #464703

    Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to check it.

  • July 9, 2003 at 11:43 am

    #464720

    THANKS, that was it.

    Joseph

  • July 9, 2003 at 1:52 pm

    #464734

    quote:

    Do you mean database available space is 0.00MB? Try to run sp_spaceused @updateusage = true to the database and go back to check it.

    What's the difference between that and "DBCC UpdateUsage"? I usually just run the DBCC command to fix things.

    Chris

    Learning something new on every visit to SSC. Hoping to pass it on to someone else.

  • July 9, 2003 at 2:04 pm

    #464737

    With @updateusage = 'true', sp_spaceused actually executes 'DBCC UpdateUsage' in it.

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

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