SCCM database consistency errors
Hello,
Running SCCM SP2 on Windows 2003 SP, database on a separate dbserver, SQL 2005. We recently had some issues with the database, found some errors while running CHECKDB agains the database. Here is the SQL message.
Check Database Integrity Task (dbserver)
Check Database integrity on Local server connection
Databases: SMS_WTH
Include indexes
Task start: 2010-07-26T03:15:02.
Task end: 2010-07-26T03:16:51.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Table error: Object ID 109347554, index ID 1, partition ID 72057594999603200, alloc unit ID 72057594907852800 (type LOB data). The off-row data node at page (1:461), slot 0, text ID 1533214720 is not referenced.
....(lots of similar errors)....
CHECKDB found 0 allocation errors and 73 consistency errors in table 'sys.xml_index_nodes_654625375_32000' (object ID 109347554).
CHECKDB found 0 allocation errors and 73 consistency errors in database 'SMS_WTH
Through trial and error we have established that this occurs during the window of time setup for the Site Maintenance Tasks. We're going to start the process of elimination and see if we can figure out which task is causing the error, but was curious
if anyone has seen errors like this in before or has any suggestions, hints, or tricks on how to patch this up. Pretty consistent that this has caused consistency errors for the last 3 weekends. Nothing much has changed with our environment, though
about 4+ weeks ago did have an issue with WSUS not synchronizing with Microsoft for the updates catalog. Microsoft's solution, reinstall WSUS. Which worked at the time. Otherwise no changes that we are aware of.
Any help or suggestions would be much appreciated, thank you.
July 26th, 2010 10:16pm


