Solved import damaged SQL MDF file

Restore from the SQL Server backups. Read in more detail here: http://www.techrepublic.com/forums/...

> 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.

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/...