SCCM 2007 data corruption

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?
LVL 1
SrikantRajeevAsked:
Who is Participating?
 
Nagendra Pratap SinghConnect With a Mentor Commented:
root cause can be found if you work in environment daily. For outsiders like us it is hard.

Just follow the best practises for all parts/servers/san etc.
0
 
Nagendra Pratap SinghCommented:
Restore from backup.

For root cause, ask a DBA.
0
 
merowingerCommented:
MS Support.
Probably you have to reinstall....
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
SrikantRajeevAuthor Commented:
DBA mentioned cause is possible missing or invalid keys for the index row matching.
But what caused this? Root cause?
0
 
merowingerCommented:
I had a similar problem after our SAN where our SQL Database was located on had a crash.
From this time one we had mayor problems within our database.
Backup was too old....too pitty
0
 
SrikantRajeevAuthor Commented:
Any one .....
0
 
SrikantRajeevAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.