SQL logs

[zak2011]

My SQL logs are really growing. From the SQL backup job properties  the daily are set to backup transaction log backups to truncate after the backup and the weekly is set for Full Backup entire database or filegroup . Is there any other possible reason why the logs are growing.

Thanks! 

[pkh · Accepted solution]

Truncating the logs does not compress them.  You got to use the SQL DBCC Shrinkfile command to compress them.  See this document

http://www.symantec.com/docs/TECH9139

[zak2011]

Thanks pkh . Will try this out and update you.