Extract .mdf from .bak in SQL Server 2005
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?
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?
RiteshShah
without restoring .BAK, you can get your .MDF file
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 available to repair your *.bak file and if its not possible, then you can't restore *.mdf file from your *.bak file.
Since your *.bak file is corrupted, then you can try for any commercial tools available to repair your *.bak file and if its not possible, then you can't restore *.mdf file from your *.bak file.