December 6, 2013 at 3:52 pm
How Can Restore Only .mdf file from .Bak file in Sql server 2008.we have only .bak file (large size)
December 7, 2013 at 12:09 pm
A bak file (provided the backup uses the normal convention of full backup files carry the bak extension) contains ALL the needed data to restore the database.
So your question is unclear. What is the issue you are trying to solve?
CEWII
December 7, 2013 at 1:08 pm
A restore has to create an entire database, hence mdf and ldf. The log file is not an optional part of the database.
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
December 8, 2013 at 3:07 am
Thanks For your Answer.
my problem is when i try restore database after 100 % ( still run 3 hours but no response/not any error message showing )
(.Bak file size 10 GB , Free space in C: Drive : 185 GB, D: Drive 60 GB, i have try to restore database in both drive , OS: window server 2003, sql server 2008)
December 8, 2013 at 5:40 am
You're going to have to give us a lot more info than that to help you debug.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply