Rebuild MS SQL log file

ALTER DATABASE <db> REBUILD LOG ON (NAME=<db>_log, FILENAME='E:\*log.ldf') ;