Link to home
Create AccountLog in
Avatar of SrikantRajeev
SrikantRajeev

asked on

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?
Avatar of Nagendra Pratap Singh
Nagendra Pratap Singh
Flag of Australia image

Restore from backup.

For root cause, ask a DBA.
MS Support.
Probably you have to reinstall....
Avatar of SrikantRajeev
SrikantRajeev

ASKER

DBA mentioned cause is possible missing or invalid keys for the index row matching.
But what caused this? Root cause?
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
Any one .....
ASKER CERTIFIED SOLUTION
Avatar of Nagendra Pratap Singh
Nagendra Pratap Singh
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks