Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Negative number in SP_Spaceused Expand / Collapse
Author
Message
Posted Tuesday, December 18, 2012 5:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 22, 2013 10:15 AM
Points: 41, Visits: 155
Hi all,


DBName 159423.88 MB -1234567mb

As the title says, the unallocated space was a negative number, and that is AFTER having run DBCC UpdateUsage.

However, i ran -

Exec sp_spaceused @updateusage = true

Which gives me unallocated of 13234.94 MB

Is there anything else I can hit the system with to force it to return true figures?

Cheers,


BLL
Post #1397706
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse