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?
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_LOGdbcc 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/...
Ad Choices