Data Used bigger than Data Size

[Karyn]

One of our databases has the following sizes:

Data used : 4017.14MB (191.29%)
Indexes 35.48 mb (1.69%)
Unused : 5.27 MB (0.25 %)
Unreserved: -1957.89 mb (- 93.23 %)
Total Size 2100MB

looking at this the data size is 2100Mb and the data used is more at 4014.14MB.

How can I sort this out, do I simply need to create another device and expand the database or do I need to do something else?

Cheers

[rogerjh]

The numbers do not look correct. I would run DBCC UPDATEUSAGE 'database_name', which updates the sysindexes table in the specified database, and should return the correct space utilization for the database.


------------
Karyn at 2/20/2002 9:42:42 AM


One of our databases has the following sizes:

Data used : 4017.14MB (191.29%)
Indexes 35.48 mb (1.69%)
Unused : 5.27 MB (0.25 %)
Unreserved: -1957.89 mb (- 93.23 %)
Total Size 2100MB

looking at this the data size is 2100Mb and the data used is more at 4014.14MB.

How can I sort this out, do I simply need to create another device and expand the database or do I need to do something else?

Cheers