You SHOULD have both daily and weekly backup/maintenance plans setup. If you don't, use the Wizard in SQK Server Management Studio.
The wizrd is good BUT the wizard doesn't have options to truncate/shrink transaction logs.
You'll need to create your own Maintenance Plan using your own T-SQL statements
I use the T_SQL statement:
DBCC SHRINKFILE (<Logfile>, <target_size_in_MB>);
As far as schedulng the task, you'll need to adjust the frequency accordingly. I do it weekly.
I have 2 subplans in my PDM maint plan as well.
- Daily Backup
- Weekly Index Rebuild/Reorg, Shrink DB
I haven't seen our logs get out of control since PDME 2007 but it's not a bad idea to shrink those as well. When we upgraded from 2007 to 2009 we saw that our log for our vault db was insanely huge. I think after the upgrade we ran a script like that once and all has been well since.