TRUNCATE_ONLY is obsolete in 2005:
"BACKUP LOG WITH TRUNCATE_ONLY (NO_LOG) is obsolete. Consider using the SIMPLE recovery model to automatically truncate the transaction log."
Just IMHO: simple recovery model advice looks weird here since the message is a result of manual and not automatic query.
Wednesday, May 04, 2005 9:33 PM