Data recovery from an Index

Question

Data recovery from an Index

VastSQL

SSC-Dedicated

Points: 36278
More actions
August 7, 2025 at 5:00 am

#4631855

Comments posted to this topic are about the item Data recovery from an Index

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

happycat59 One Orange Chip Points: 29451 More actions · Answer 1

I had a corruption in a SQL 6.5 database. Thankfully in a single table. and better yet, I managed to recover 100% of the data using a combination of the non-corrupt data in the clustered index and non-clustered index. Selected most columns from the clustered index and from the non-clustered index, I selected the (unique in this case) clustered index (a PK) and the columns that were corrupt.

George Vobr SSChampion Points: 10114 More actions · Answer 2

This topic is described in the documentation in Use index rebuild to recover from data corruption

Robert-378556 SSCertifiable Points: 5976 More actions · Answer 3

The correct answer would be "Yes, but only if the index pages are intact and for indexed columns only", original "correct answer" is wrong.