So i am urgent looking for a reliable solution which help to recover and restore .mdf file of SQL server. Any suggestion will be appreciated.

The only suggestions I can find to fix this is to use the DBCC CHECKDB command with REPAIR_REBUILD; the problem, of course, is that the SQL Server won't even attach this MDF file in the first ...