By David Fekke
January 17th, 2011
If you use the following statement to empty our your transaction log, beware.
This option has been deprecated, and Microsoft is not planning on having the TRUNCATE_ONLY option in SQL Server 2007.
Another option is detaching the database, and then reattaching without the log file. SQL Server will recreate the LOG file from scratch.