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