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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment