Question about Microsoft SQL Server 2005 Enterprise Edition for PC

5 Answers

Import damaged SQL MDF file

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?

Posted by on

Ad

5 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Microsoft Expert
  • 43 Answers

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

Ad
  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

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

Ad
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 7 Answers

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

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

  • Contributor
  • 3 Answers

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

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 294 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

7 Answers

Repair a corrupt SQL database in SQL 2005


Known as the leading solution provider in the field of data recovery and data conversions, the company has created a niche for another efficient tool known as SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as SQL scripts or exports directly to Microsoft SQL Server through direct connect. read more details SQL Server Repair Toolbox

Jun 13, 2015 | Microsoft SQL Server 2005 Enterprise...

4 Answers

Better and safe way to repair and recover MDF files


To choose a reliable and 100% safe and secure, a SQL server database recovery utility guarantee the zero loss of quality. You can refer to this page: http://www.sqlrecovery.org and also read this post http://recoverymaster.livejournal.com/519.html

Jun 04, 2014 | Microsoft SQL Server 2000 Standard Edition...

16 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

7 Answers

How to recover SQL server mdf files?


RecoveryFix for SQL database recovery software is recover and repair MDF files components from corrupted SQL server database. This software compatible with Windows 7, Server 2008, Vista, Server 2003, XP and 2000. More details see this site: http://www.en.repairsqlserver.net/ or download this tool from http://www.en.repairsqlserver.net/free-trial.html

May 06, 2014 | Microsoft Database Software A5K-02817 SQL...

5 Answers

How to recover deleted Microsoft SQL server MDF files?


Recover and repair MDF files with simple and efficetive tool to repair and recover MDF files from corrupt and damaged SQL server, which tool support all king of SQL server version and Windows OS. Visit here: http://www.en.mdfrepair.net
Read blog post: http://exchangerecovery.hubpages.com/hub/How-to-perform-SQL-Database-Recovery Corrupt MDF File Repair Utility

Apr 17, 2014 | Computers & Internet

8 Answers

How can i fix the problem by error message 262,level 14,state 1,line 1 CREATE DATABASE permission denied in database 'master' in sql server 2005


RecoveryFix for SQL server database recovery utility is a very powerful utilty to fastly short out your all problems to MS SQL database. By using this application, user can simply repair SQL database. Read more: http://www.sqlrecovery.org/download.html
For more information read this post: http://diskdatarecovery.jimdo.com/2013/07/23/how-to-restore-lost-data-on-server-while-running-sql-server/

Jun 22, 2010 | Microsoft SQL Server 2005 Enterprise...

Not finding what you are looking for?
Microsoft SQL Server 2005 Enterprise Edition for PC Logo

Related Topics:

230 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2764 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18394 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...