You may use any manual method to repair it but problem is that manual method is very complicate and has very long steps which take much more time to process and sometime in major condition it doesn't work then in this case you should take help of any third party software which are available in huge number on internet.
But I would recommend you to use this SQL database recovery software which can easily resolve all types of corruption issue which you see on top of this post. It is fully capable to restore all the SQL file objects such as tables, views, triggers, stored procedures, constraints, default constraints, indexes, rules, user defined functions & user defined data types.
This software successfully recovers SQL database objects from the corrupt or damaged MDF files and restores them as well. This software is very reliable which allow all users to easily use this software without any technical skill.
Visit here to know more:- http://www.filesrecoverytool.com/sql-database-repair.html
Use the reliable software is ZOOK Data Recovery Software to recover deleted data from various items. The tool offers to recover unlimited data from various devices such as hard disk, hard drive, pen drive, SD card, etc. Anyone can easily perform data recovery even after formatting, deleted items from recycle bin, partition recovery, etc. This utility is capable enough to restore multiple files such as photos, videos, emails, etc. It supports FAT 16, FAT32, NTFS, etc. file system to recover the deleted items. It is a safe and secure utility to restore the files.