Leo (10/18/2008)
I never backup the transaction log even database model is -FULL. transaction log backup is not required for my environment at the moment.
You need transaction log backups in full recovery because if you don't, your transaction log will grow without bound, as you're seeing.
If you don't need point-in-time recovery, then switch the database to simple and you won't have to worry about the transaction logs. If you do need point-in-time recovery, then set up regular log backups.
See - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
if you suggest to do that, 'Before' or 'After' my Maintenance Plan?
*****
BACKUP LOG t_log_name WITH TRUNCATE_ONLY
DBCC SHRINKFILE (t_log_name,amount,retain )
*****
Neither. Switch to simple recovery if you have no need of log backups. Then you won't have to worry about doing that at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability