I get this question all of the time, and there is a great support article from Microsoft on how to do this. One of the ways to truncate the log file is to simply detach the database and re-attach it without the log. I DO NOT recommend that unless it is...