Negative Free space being reported on a SQL2000 db

[UpstateNYAdmin]

(SQL2000 std SP3a on Win2k3)
One of my databases is show negative free space of 9000% in Quest spotlight and 0 MB free in SQLEM when I view the db properties. Does any one know how to correct those stats? I have already done several DBCC CHCKDB and CHECKTABLEs on that database. I suspect it could be due the db file fragmentation, so I want to exhaust everything while its online before I backup and restore. I had another db that had the same issue and the CHECKDB seemed to fix it.

 

[ptheriault]

run DBCC UPDATEUSAGE

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ptheriault]

You will need to include the db name like this.

DBCC UPDATEUSAGE([db_name])

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[UpstateNYAdmin]

That did the trick! Thanks!!

 

[ptheriault]

no problem

- Paul
- If at first you don't succeed, find out if the loser gets anything.