Hi today i was trying to attach an .mdf file which was not having the .ldf file with it, sql server was giving error with it but later i found a workaround. So to attach a .mdf file without its .ldf file just press remove button at the creation windows in your sql server management studio. It will remove the .ldf file location and create a new .ldf file for your database. Here is a link of how to do this. http://img.photobucket.com/albums/v472/Schmedrick/attach.gif
