Sometimes after a Recover by record headers, a verification will result in errors.



As stated by the Repair Page documentation:

The Recover by record header function in MSC is a " low-level repair option only when the data file is severely damaged and after all other solutions (restoring from a backup, standard repair) have proven to be ineffective."

This is because a Recover by record headers ensures that the recovered records are not damaged, it does not guarantee anything associated is restored, such as relational constraints between the restored record and other records. Hence errors are generated due to these associations not being restored.

A manual inspection on the dataset should be performed after any Recover by record headers. Especially the tables do not have the ‘records definitely deleted’ setting checked, where any deleted record may reappear.