March 26, 2015 at 1:30 am
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?
March 26, 2015 at 2:43 am
The ldf file isn't in the backup. All that's in the backup is the data and what was the active portion of the log at the time of backup. If the backup failed part way through, it likely won't be restorable (it's not like a zip file containing the files separately)
What error do you get if you try to restore the backup? Use T-SQL not the GUI and the CONTINUE_AFTER_ERROR option.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 26, 2015 at 1:14 pm
Please try:
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply