i want to know that whether there is any provision in SQL Server 2008 to restore MDF file only from the bak file excluding the log file.
i just want to know because, the bak file which i have is close to 4-5 GB, but after specifying the details while restoring the database, then it is consuming close to 80 GB as 30GB for the MDF file or 50 GB for log file.
But say for once, the total hard disk is 80 GB.
all the given figures are approximate except for Hard Disk size.
in that case, i only want to extract the MDF file while excluding the LOG file for the database to attach.
Looking for favorable replies.
View Complete Post