InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 10:52:52 GMT20http://www.sqlservercentral.com/Forums/Topic1403724-1292-1.aspxI ran the DBCC UPDATEUSAGE command without incident. The DBCC CheckDB runs fine. I don't have any experience dropping and recreating an index. What I've done is take a backup of the database (with the corruption) and will attempt this in a test environment. Learning process continues... Thank you both for responding.Tue, 08 Jan 2013 08:36:11 GMTjralston88http://www.sqlservercentral.com/Forums/Topic1403724-1292-1.aspx[quote][b]WolfgangE (1/7/2013)[/b][hr]Maybe - and I really mean MAYBE - you can solve the problem by rebuilding the indexe mentioned in the error message.[/quote]Dropping and recreating should solve this particular corruption.Mon, 07 Jan 2013 12:44:21 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1403724-1292-1.aspx"take long" is quite relative. In the enviroment I know we lose data if a table is locked for more than 30 seconds. As far as I have seen the UPDATE-USAGE-command places a lot of locks and on tables with some million records the command runs much longer than 30 seconds.Maybe - and I really mean MAYBE - you can solve the problem by rebuilding the indexe mentioned in the error message. Depending on the SQLServer-version you use you can do an online rebuild which should hold only minimal locks. I don't believe an index reorg will work but it would be another try.Mon, 07 Jan 2013 12:32:46 GMTWolfgangEhttp://www.sqlservercentral.com/Forums/Topic1403724-1292-1.aspxJust run exactly what the error says - DBCC UPDATEUSAGE. Doesn't usually take that longMon, 07 Jan 2013 10:33:04 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1403724-1292-1.aspxDBCC CheckDB job failed last night. This is SQL Server 2005 Enterprise Edition 64 bit environment. The message / solution indicated running "DBCC UPDATEUSAGE".This is a first for me, should the command be run against the database? Or against the table listed? I'm assuming this should be run during a maintenance window. Error message is as follows: Progress: 2013-01-06 12:00:05.17 Source: Execute T-SQL Statement Task Executing query "USE [xxx] ".: 50% complete End Progress Error: 2013-01-06 12:01:21.03 Code: 0xC002F210 Source: Execute T-SQL Statement Task Execute SQL Task Description: Executing the query "DBCC CHECKDB WITH ALL_ERRORMSGS" failed with the following error: "The In-row data USED page count for object "Project_SubFees", index ID 9, partition ID 2544946730696704, alloc unit ID 2544946730696704 (type In-row data) is incorrect. [b]Run DBCC UPDATEUSAGE[/b]. The In-row data RSVD page count for object "Project_SubFees", index ID 9, partition...The package execution fa... The step failed.Any comments would be appreciated - thank you.Mon, 07 Jan 2013 09:59:30 GMTjralston88