Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 @ 6:37 PM
Points: 33,189, Visits: 15,329
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: Today @ 3:51 AM
Points: 42,814, Visits: 35,936
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 2008, MVP
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
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse