Solved

import damaged SQL MDF file

Posted on 2013-11-07
3
400 Views
Last Modified: 2013-12-11
I have a PC that had sql 2005 running on it that has died. The OS is corrupt and wont boot / repair at all.

I have managed to get the MDF file off of the machine but I cant attach it to another SQL server because it is damaged.

How can I go about trying to repair this file?
0
Comment
Question by:CaptainGiblets
3 Comments
 
LVL 33

Expert Comment

by:Big Monty
ID: 39630349
if you want to pay for a solution, you could check out this tool:

http://www.systoolsgroup.com/sql-recovery.html
0
 
LVL 6

Author Comment

by:CaptainGiblets
ID: 39630403
I have seen a few of these but preferably I would prefer a free option.
0
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39630618
I would recommend taking a look at this blog for how to attach damaged datafiles (which would then allow you to attempt recovery): http://blogs.msdn.com/b/suhde/archive/2009/05/12/database-corruption-part-2-how-to-attach-a-database-using-the-create-replace-method.aspx?Redirected=true
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question