CHECKDB found 0 allocation errors and 1 consistenc

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

CHECKDB found 0 allocation errors and 1 consistenc

Author

Topic

shikha
Starting Member

1 Post

Posted - 2009-05-11 : 07:42:12

Hi,

I am getting this given error when maintenance plan run.

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "The In-row data RSVD page count for object "SALARY.StaffPlanning_FACT", index ID 0, partition ID 91956972355584, alloc unit ID 91956972355584 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'SALARY.StaffPlanning_FACT' (object ID 1403152044).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'DataWarehouse_CP'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

anyone has idea to resolve this error.
updateusage can run any time or in off hour only.
Thanks,
Shikha

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-05-11 : 09:33:24

As the message says, run DBCC UPDATEUSAGE

To be safe, run it out of business hours.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources