Mac1986 (2/14/2013)
Is there a way than I can just restore the data and not restore the log file. OR create a an empty log file while restoring and not considering the huge log file from the .BAK file?
No. You'll need to find the disk space to restore the DB. A restore puts the database down as it was at the time of backup, file sizes included.
p.s. Log files aren't optional files that you can just not restore or delete without consequence.
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