dslreports logo
 
    All Forums Hot Topics Gallery
spc
Search similar:


uniqs
492

exocet_cm
Writing
Premium Member
join:2003-03-23
Brooklyn, NY

exocet_cm

Premium Member

[Windows] SQL assistance with backsups (nothing critical)

Click for full size
I have my SQL servers (three of em) making regular backups of my "mission critical" databases every Tuesday and Friday at 0500 hours.

I have it set to keep the last 5 backups and flush the oldest. Apparently I don't have it set to flush the transaction log backup. Is there a way to delete these old transaction log backups with the old DB backup file or do I need to do it manually?

quaker
Premium Member
join:2001-12-27
Rocky River, OH

quaker

Premium Member

just create another maintenance cleanup plan to clean up the .trn files same way your cleaning up the .bak files