How to Recover SQL Database?
If you have latest backup of SQL backup file then restore it, otherwise you can run the DBCC CHECKDB command, it helps you recover SQL database, if this command is not properly work then last option is third party tool i.e SQL recovery which can help you to repair mdf file. Get full details of this tool: http://www.sqlrecoverysoftware.net/sql-server-mdf-file/