SCCM 2007 data corruption
Posted on 2013-05-23
During my daily check on the SCCM database, I ran into the error....
Data row of table 'ResPolicyMap' does not have a matching index row in the index 'ResPolicyMap_PADBID_MachineID_idx'.
Please let me know what data is stored in the ResPolicyMap table?
What are the reasons this issue could have occured?
To resolve the issue...
1. Changed database option to single user mode.
2. executed command DBCC CHECKDB('SMS_CNH', REPAIR_REBUILD)
3. executed command DBCC CHECKDB('SMS_CNH')
*** More importantly I need to understand the root casue why this happend in the first place?