Question about Microsoft SQL Server 2005 Enterprise Edition for PC
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?
Use the following steps
1. Create a Sample Database called TEST with as many MDF Files and LDF Files as the Corrupted one.
2. Stop SQL Server
3. 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.
4. Restart SQL Services
5. Database would come up in suspect.
6. 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')
7. Run dbcc checkdb as well.
If this fails to fix your problem then you can take the help of third party recovery tool like: www.dbpros.org/sql-server/mdf-recovery.html
Posted on May 13, 2016
I would like to suggest you to use of MDF Repair Kit. An exciting new product from Repair Kit, this MS SQL MDF repair tool is an absolutely indispensable tool for anyone who wants to know how to repair MDF files in minutes. The program is based on a powerful analysis core and uses a convenient wizard-driven UI.
For more: http://www.mdf.repair/
Posted on Apr 26, 2015
Stellar Phoenix SQL Server Recovery application to restore SQL database. For storing a large amount of data in the database manually takes a huge amount of time and the method is also very complex. However, by utilizing this tool one can perform SQL database repair and recovery in an easy and hassle free environment.
Posted on Feb 08, 2017
Easiest way to recover for SQL database, you can use SQL Database Recovery Software SQL Recovery Tool which can easily repairs corrupt MDF file of SQL Server database. And that software also recover tables, triggers, indexes, keys, constraints, rules, and defaults.
Posted on Jun 06, 2016
Restore the MDF file from your backups.
Yeah, I know. Everybody knows they should back up important stuff but...
You can try a file repair on the copy with this SQL Recovery Software Recover Repair Corrupted MDF Database Files
I've used it before successfully in an enterprise environment. Your mileage will vary.
Posted on Apr 25, 2015
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...
Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...
May 12, 2014 | Microsoft Database Software A5K-02817 SQL...
May 06, 2014 | Microsoft Database Software A5K-02817 SQL...
Apr 17, 2014 | Computers & Internet
Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...
235 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: