How to view content damaged MS SQL Server database?

Tags:
SQL Server
SQL Server database
Help!
Dead computer and all the information. Computer to reinstall formatting (otherwise failed). With the help of programs to restore files managed to pull Fail SQL database (.mdf). But on the other computer does not accept the file. Writes an error. Already tried everything. How do I restore the file? There's work for 2 years. HELP
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Hi, hanamor1100,

Just try SQL MDF Viewer which easily view data from healthy as well as corrupted MDF Files of MS SQL Server Database. You can download it, its free from here:

Thanks & Regards

Clark Kent

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Do you have any systems back ups? You might recover some data depending on the date of the last. Try Clark's option first and see if you can actually view the database and save to another source. Hopefully it's not a hardware problem.
    136,960 pointsBadges:
    report
  • Colin Smith
    If you do not have any backups and you have to recover the database from the mdf, did you try to mount the database with a recreate of the log file?
    http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/
    Just know the database may lose data that was in the log. Also can you post the error that you are getting in the log?

    945 pointsBadges:
    report
  • Subhendu Sen
    First backup the tail log then attempt for a test restore on another system (if you have) Now restore last good full backup with no recovery. However there are several repairing tools that you can try.
    144,140 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: