Error: 644 - help

[abcduser]

Hi,

After a backup and restore, this error is appearing (not sure from where, someone just sent this info to me)...

does anyone have any idea what the problem is? And the best fix?

Running dbcc checkdb does point to some errors with the data... but frankly, not sure how to resolve this.

Any help greatly appreciated!!

Thanks


DESCRIPTION: Error: 644, Severity: 21, State: 3
Could not find the index entry for RID '360000200104404406507604d06706d07405306507207606507204306f06e0660690670' in index page (1:322), index ID 0, database 'myDB'.

 

[mrdenny]

Your index has become corrupt. When you run DBCC CHECKDB it should tell you what repair setting needs to be used to correct the error.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[mrdenny]

If you can post the full output from DBCC CHECKDB we can point out the repair level.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog