About fixing metadata, I'm not discussing about the complexity of parsing the files and checking each page's content and I really don't want to go this way. When I said simple logic, once you know the internal structures and have code to handle all that parsing, the high-level logic to accomplish that next step is simple.
Um, no. If it was simple, CheckDB would do it already. It's not simple, it's damned hard, it's not always possible. But since you're not interested in such useless pollution, I'll leave the thread to others
My experience with 3rd party recovery tools is that they don't work. I've tried a couple in cases where there were no backups and CheckDB failed and they retrieved nothing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability