How to clean Up database log files under SQL Server R2

Nonsense not much to say, directly on the code, clean up after the log file is 1M

[SQL]View Plaincopyprint?

2. Use [master]
4. GO
6. ALTER Database [db name] SET RECOVERY simple with no_wait
8. GO
10. ALTER Database [db name] SET RECOVERY Simple
12. GO
14. Use [database name]
16. GO
18. DBCC shrinkfile (N' [Database log file name] ', 0,truncateonly)
20. GO
22. Use [master]
24. GO
26. ALTER Database [db name] SET RECOVERY full with no_wait
28. GO
30. ALTER Database [db name] SET RECOVERY full
32. GO
36. --Query the log file name of the specified database
38. Use [database name]
40. GO
42. SELECT name from sys.database_files WHERE type_desc=' LOG '

08r2 passed, other versions not tested

How to clean Up database log files under SQL Server R2