Showing posts with label DBCC UPDATEUSAGE. Show all posts
Showing posts with label DBCC UPDATEUSAGE. Show all posts

Wednesday, November 29, 2006

Zero Space Available on Cargo Data Device.

Recently we have encountered a problem with the Cargo Data Device. When I look at the properties of the Database from Enterprise Manager, It shows Size: xxxxx mb and space available: 0.00 . It shouldn't be zero since the database is set to autogrow at least xx mb. Apprently the sysindexes table is out of sync. Running " DBCC UPDATEUSAGE (0) " or " sp_spaceused @updateusage = true " fixed the problem.

With the later option it actually executes " DBCC UPDATEUSAGE (0) " within it.