Is it possible to restore sql-server bak and shrink the log at the same time?
There is a do-not-ever-do-this-in-a-live-environment hack you can use where space is limited, by restoring the log file to a compressed folder. Attempt this by compressing an existing folder and restoring to it will result in an error, so you have to cheat with a symbolic link.


Create a compressed folder D:\LogCompressed\
Create a symbolic link to the compressed folder mklink /D /J D:\Log\ D:\LogCompressed\
Restore your database with the ldf file pointing at D:\Log\
Shrink the log file to an appropriate size
Detach the database, move the log file to an uncompressed folder, attach


It's dirty, it's cheating, DO NOT EVER DO IT IN LIVE, but it works. Quick test of a newly created database with a 32MB log file shows it as occupying 330kb on disk when compressed, decompress the folder and on disk size is back to 32MB.