Home Forums SQL Server 7,2000 Administration SQL Database Size 0 and Unallocated space in negative ..how to Free up? RE: SQL Database Size 0 and Unallocated space in negative ..how to Free up?

  • Jeff Moden (5/30/2014)


    To fix the negative space available thing, try running the following in the database you're having problems with...

    DBCC UPDATEUSAGE (0);

    Because there are bugs in SQL 2000's free space tracking, resulting in the 'negative' space.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass