Solved

import damaged SQL MDF file

Posted on 2013-11-07
3
388 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 32

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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now