Solved

SCCM 2007 data corruption

Posted on 2013-05-23
7
405 Views
Last Modified: 2013-07-22
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?
0
Comment
Question by:SrikantRajeev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 24

Expert Comment

by:Nagendra Pratap Singh
ID: 39193287
Restore from backup.

For root cause, ask a DBA.
0
 
LVL 31

Expert Comment

by:merowinger
ID: 39193517
MS Support.
Probably you have to reinstall....
0
 
LVL 1

Author Comment

by:SrikantRajeev
ID: 39193816
DBA mentioned cause is possible missing or invalid keys for the index row matching.
But what caused this? Root cause?
0
Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

 
LVL 31

Expert Comment

by:merowinger
ID: 39193919
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
 
LVL 1

Author Comment

by:SrikantRajeev
ID: 39273774
Any one .....
0
 
LVL 24

Accepted Solution

by:
Nagendra Pratap Singh earned 500 total points
ID: 39273783
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
 
LVL 1

Author Closing Comment

by:SrikantRajeev
ID: 39346904
Thanks
0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question