Solved import damaged SQL MDF file

Microsoft Sql server 2005 standard editi...
April 26, 2015 at 13:25:09
Specs: Windows 7, 3,5 gb i3
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?


See More: import damaged SQL MDF file

Report •


#1
April 28, 2015 at 00:21:51
✔ Best Answer
Restore from the SQL Server backups. Read in more detail here: http://www.techrepublic.com/forums/...

Report •

#2
November 4, 2016 at 22:14:12
> Create a Sample Database called TEST with as many MDF Files and LDF Files as the Corrupted one.
> Stop SQL Server
> Copy the Corrupted database MDF File onto a different location as backup. Rename the MDF file to TEST_Data.mdf.And Replace the TEST MDF File with the Corrupted Database MDF File.
> Restart SQL Services
> Database would come up in suspect.
> Since Log File will not be linked to the new MDF File you have to run DBCC REBUILD_LOG

dbcc rebuild_log('dbname','New Log File NAme')

> Run dbcc checkdb as well.

But it could result in Data Loss

So it is better to use third party tool to recover corrupt MDF file without any lose of data.


Report •

#3
February 9, 2017 at 04:41:17
Well, in this case make use of the professional MS SQL File Repair tool, to recover and repair the corrupted, damaged and any type of error in the SQL Server database. This is the best tool to recover and restore almost every items of the corrupt database including keys, tables, stored procedures, views, indexes, triggers, deleted records and many more.
To Know More Visit: http://www.filerepairtool.net/blog/...

Report •

Related Solutions


Ask Question