Help, my transaction log file is huge!
Discuss active portion of log
DBCC OPENTRAN
full backup will always back up active portion of log, even simple recovery model