>See my blog on this topic
>
>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/truncate-log-in-all-your-user-databases
>
>>Did George explain WHY tempdb is not skipped?
>
>BTW, I think the correct solution would be to query the current DB recovery model and restore it at the end. I'll research on this later.

See also important comments on that blog.

Steps to better Transaction Log throughput
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Transaction Log VLFs - too many or too few?
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx