Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

corrupted mdf file Expand / Collapse
Author
Message
Posted Sunday, March 30, 2014 10:48 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:21 PM
Points: 33,667, Visits: 17,754
betty_bakke (3/29/2014)
Hello,

Through a manual solution you can restore data from your corrupted .mdf database. It can be done by executing DBCC CHECKDB and DBCC DBREPAIR statements in MS SQL Server as a new query. For step by step process to execute these statements, you can refer to this blog post: Recover corrupted MDF File.


NOTE that DBCC DBREPAIR is not recommended. I would be very careful about using any of these tools.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1556289
Posted Sunday, March 30, 2014 2:22 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:01 PM
Points: 44,597, Visits: 42,322
Steve Jones - SSC Editor (3/30/2014)
NOTE that DBCC DBREPAIR is not recommended. I would be very careful about using any of these tools.


More drive-by spam. This stuff gets posted on any thread remotely resembling corruption, no matter whether or not the posted 'advice' has any relevance. :-(



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1556300
Posted Wednesday, February 24, 2016 10:24 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 20, 2016 10:41 PM
Points: 187, Visits: 222
If you have a backup of the database, then it is the best time to use it. Before restoring database from backup, you need to verify it. As SQL server backup is also get corrupt.

But if you don’t have a healthy backup, then you can try third party MDF Recovery Tool to repair corrupt .mdf file
Post #1764119
Posted Thursday, February 25, 2016 12:40 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 3:01 PM
Points: 44,597, Visits: 42,322
5-year old thread


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1764139
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse