"dbcc checkdb('') with no_infomsgs" failed with the following error: "The In-row data USED page count for object "", index ID , partition ID , alloc unit ID (type In-row data) is incorrect. Run DBCC UPDATEUSAGE

As most of us are aware that DBCC CheckDB is one of the most important DBCC Command which is used to check for database integrity and corruption and consistency.

DBCC CheckDB may come up with many Error but today i will be going through one such error.

The error is as mentioned below.

"dbcc checkdb('') with no_infomsgs" failed with the following error: "The In-row data USED page count for object "", index ID , partition ID , alloc unit ID  (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.

Below mentioned are the some of the possibilities for this error.

1.This error generally occurs when inaccuracies are found in rows, used pages, reserved pages, leaf pages and data page counts for each partition in a table or index. 

2. This error occurs because DBCC CheckDB has found an incorrect value on page for the USED space.

3. This might have happened because the database on which you are running DBCC CheckDB is upgraded from SQL Serer 2000 version and in SQL 2000 it was possible for the row and page counts for a table or index to be incorrect, even negative.

4. This error also might occur if there are more DDL statements being issues more frequently on a database.

The resolution to this is very simple as stated in Error itself.

Run DBCC UPDATEUSAGE(‘DatabaseName’)

If there are no inaccuracies in the system tables, DBCC UPDATEUSAGE returns no data. If inaccuracies are found and corrected and WITH NO_INFOMSGS is not used, DBCC UPDATEUSAGE returns the rows and columns being updated in the system tables.

Make sure, you run this command during off peak hours as it might take a long time to run some times.

Technorati Tags: DBCC,DBCC UPDATEUSAGE,DBCC CHECKDB,In-row data,type In-row data