|> Create a Sample Database called TEST with as many MDF Files and LDF Files as the Corrupted one.|
> Stop SQL Server
> Copy the Corrupted database MDF File onto a different location as backup. Rename the MDF file to TEST_Data.mdf.And Replace the TEST MDF File with the Corrupted Database MDF File.
> Restart SQL Services
> Database would come up in suspect.
> Since Log File will not be linked to the new MDF File you have to run DBCC REBUILD_LOG
dbcc rebuild_log('dbname','New Log File NAme')
> Run dbcc checkdb as well.
But it could result in Data Loss
So it is better to use third party tool to recover corrupt MDF file without any lose of data.