maintenance task sql 2008 management studio

I have a maintenance task that deletes all .bak files after a 15 day period.
it's not deleting .trn files...
is there a way to make this task delete .trn and .bak files with the same task.
Thanks a bunch
experts-exchange-sql-main-task.jpg
jamesmetcalf74Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
If your backups are in a single folder then you can provide the folder name and delete all files (*).
0
 
Scott PletcherConnect With a Mentor Senior DBACommented:
Click the "Help" button on that screen.  It should further describe the columns on the screen, including the file extension.   The wording seems to indicate that it's only a single value.  If so, you could set up a second maintenance task to do the .trn files.
0
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
<<If your backups are in a single folder then you can provide the folder name and delete all files (*).>>
Or perhaps remove the folder if the folder contains only the backups for a specific term.  A much faster operation.  ;)
0
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
It seems you do not have a log cleansing process in your current log backup job or step.  Please identify the log backup job or step maintenance and copy it while adding cleansing in the new job.  You then only have to disable the old log backup job/step
0
 
jamesmetcalf74Author Commented:
Thanks guys
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.