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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics