Sunday, February 19, 2012

DBCC CHECKDB WITH NO_INFOMSGS Error

When I run either "DBCC CHECKDB WITH NO_INFOMSGS" or using "check database integrity" in maintenance plan, I always got an error below:

The In-row data RSVD page count for object "tablename", index ID 0, partition ID 76911687696384, alloc unit ID 76911687696384 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'tablename' (object ID 1173579219).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'dbname'.

Can anyone help me please?

Regards,

What happens after you run DBCC UPDATEUSAGE?

Denis the SQL Menace

http://sqlservercode.blogspot.com/

|||

Thank you Denis. It was perfect after running DBCC UPDATEUSAGE('dbname').

Cheers,

No comments:

Post a Comment