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.
| Author |
Topic |
|
sscrutchfield
Starting Member
1 Post |
 Posted - 2008-09-30 : 11:32:12
|
| I am receiving an error on my maintainance plan regarding the db consistency, below is the message:Executing the query "DBCC CHECKDB WITH NO_INFOMSGS" failed with the following error: "The In-row data RSVD page count for object "pclip.udf3", index ID 0, partition ID 42308556423168, alloc unit ID 42308556423168 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.The In-row data RSVD page count for object "pclip.udf13", index ID 0, partition ID 84251745845248, alloc unit ID 84251745845248 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.The In-row data RSVD page count for object "pclip.udf14", index ID 0, partition ID 88446064787456, alloc unit ID 88446064787456 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.CHECKDB found 0 allocation errors and 1 consistency errors in table 'pclip.udf3' (object ID 645577338).CHECKDB found 0 allocation errors and 1 consistency errors in table 'pclip.udf13' (object ID 1285579618).CHECKDB found 0 allocation errors and 1 consistency errors in table 'pclip.udf14' (object ID 1349579846).CHECKDB found 0 allocation errors and 3 consistency errors in database 'pclip32'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.What do I need to do to resolve this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-30 : 23:29:20
|
| https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2333936&SiteID=17&pageid=0 |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-10-07 : 09:16:39
|
| As the message says, run DBCC UPDATEUSAGE--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
Consistency error on SQL 2005 DB