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: Today @ 5:38 PM
Points: 31,355, Visits: 15,819
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 @ 8:37 AM
Points: 40,596, Visits: 37,053
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
Posted Wednesday, November 19, 2014 12:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 12:03 PM
Points: 2, Visits: 1
When you do this you will get an error about the log file missing. This shouldn’t matter as SQL Server will

simply create a new log file for you.

This will only work if the SQL Server was stopped when you copied the MDF file from the old SQL Server. If you

copied the file while the SQL Server was running this file probably will not attach either and you will need to

get a valid backup of the database.
Download help tool for sql database - SQL Server Restore Toolbox.
http://www.sqlserver.restoretools.com/
You can read up more on SQL Server here.
http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/498-creating-a-new-database-using-an-mdf-file?_=1416149856104
Post #1636448
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse