User-169434202 posted
Hi AhmadRock
1) Try to repair the database with DBCC CHECKDB Commands. I suggest you to read Microsoft article on database recovery to understand how you can repair that corrupt MDF Database, but keep in mind to choose wisely between various syntaxes (REPAIR_ALLOW_DATA_LOSS
| REPAIR_FAST | REPAIR_REBUILD) as there is fair chances of some potential data loss and you need to make decision whether you are ready for that and if yes, then to what extent.
http://technet.microsoft.com/en-us/library/ms176064.aspx
2) There is another alternative and I suggest you to take into consideration. There are many SQL Data recovery software in the market that perform more or less the same, but have a fairly better probability of full database retrieval from corrupt database.
There is one nice wiki article and if you decide to choose this alternative then go through all the steps mentioned over there and if you follow those every steps correctly then hopefully you will be able to retrieve fully your database
http://www.wikihow.com/Perform-MS-SQL-Database-Recovery-Through-Software
Hopefully if you try one or all of the methods you will be able to recover your database.
Regards
dimeshwilliam
