How to extract .mdf from .bak in SQL Server 2005

  • Thread starter Thread starter EmerysMontgomery
  • Start date Start date
  • Tags Tags
    Server Sql
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
1 replies · 2K views
EmerysMontgomery
Messages
1
Reaction score
1
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?
 
  • Like
Likes   Reactions: horacek
on Phys.org