Info from .bak in SQL Server 2005

45 pts.
Tags:
.bak file
SQL Server
I have a 6GB .bak file that, when check it in the file to use for restore, the file shows 'Incomplete'. I need to extract the .mdf part of the .bak file since I don't need the .log file. There should be some way to do this or some tool out there that will either repair the .bak file so it doesn't show 'Incomplete', or that will extract the .mdf file so I can use it or repair just the .mdf file. There may even be a SQL script that will do this. I've done extensive searches and can't find an answer. I'm quite sure I'm not the only one who has encountered this issue. Suggestions/solutions?

Answer Wiki

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

Without restoring a *.Bak file into a database, you would not be able to obtain the mdf and ndf files present in it. Since your *.bak file is corrupted, then you can try for any commercial tools for SQL database recovery (for example there is a good SQL Server Recovery Toolbox) available to repair your *.bak file and if it’s not possible, then you can’t.

Discuss This Question: 2  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.
  • Subhendu Sen
    Focusing only as you asked for repair/ recover .bak file, please link here: https://gallery.technet.microsoft.com/Easily-Recover-SQL-Backup-9c79e2ac.
    92,160 pointsBadges:
    report
  • aragao
    I'll try to follow your instructions. thank you!)
    45 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: