Last post Jun 18, 2015 02:45 AM by Flair Blair
May 17, 2015 11:17 AM|WilliamPhill|LINK
I m using sql server 2012
and this is first time that I have faced error regarding mdf file corruption, so how can I perform the sql mdf file repair task please recommend solution.
May 17, 2015 11:52 PM|Edwin Guru Singh|LINK
As per this case, check the following details :
1.First of all ,you can try DBCC CHECKDB
command which is used to check the database corruption or in other words it checks the physical and logical database integrity.
2.If DBCC CHECKDB command finds corruption in the database then
REPAIR_FAST, REPAIR_REBUILD or REPAIR_ALLOW_DATA_LOSS can be used to fix the corruption
3.Click here to refer the syntax about DBCC
4.Sometime DBCC CHECKDB command (repair_rebuild or repair_allow_data_loss) also fails to fix corruption. In this situation you can try third party SQL repair tool. These
SQL repair tools can repair corrupt mdf & ndf file effectively .so you can choose third party SQL repair tool by consult with your database administrator.
May 18, 2015 10:13 AM|limno|LINK
Do you have a good recent backup file of your database?
You should try to use fresh backup as your first choice before you dive into disaster recovery path.
Jun 18, 2015 02:45 AM|Flair Blair|LINK
If you also want to know that in this case I want to share my personal experience with a professional application of SQL Recovery Tool. If you also have MDF files corruption issues then this software can help you to repair your damage files without facing
any problem. You can get more details about this advanced application for SQL recovery from here :