Solved

SCCM 2007 data corruption

Posted on 2013-05-23
7
401 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
  • 3
  • 2
  • 2
7 Comments
 
LVL 23

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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
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 23

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
execute a MS SQL script as a schedule SQL job 72 139
Passing value to a stored procedure 8 108
Can Unique column have more than one Null? 8 55
SQL 2016 licensing 6 62
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

820 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