SQL Server Performance

why is the unallocated space a negative number

Discussion in 'General DBA Questions' started by lindajjws, Jan 16, 2004.

  1. lindajjws New Member

    Hi there,
    I shrinked the transaction log last night. And after I did it, I used sp_spaceused to check the information. I noticed that the unallocated space is -3.89MB. How could that happen?
  2. Luis Martin Moderator

    Check Space available in Enterprise Manager, if 0, sp_spaceused show negative values.
    I don't know why, but I never had problems with that.


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  3. satya Moderator

    Run SP_SPACEUSED @UPDATEUSAGE='TRUE' to update the values correctly.
    And also to ensure you can get information from SP_HELPDB for the database.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. lindajjws New Member

    It worked! Thank you so much, Satya![<img src='/community/emoticons/emotion-1.gif' alt=':)' />]

Share This Page