SQL Server Performance Forum – Threads Archive
Transaction Logs not deleting old backupsI have a DB Maintenance plan that is also backing up trx logs hourly as well as full backups nightly. The old full backups delete themselves properly after 3 days but the trx logs are not deleting files older than 1 week. Does anyone have any ideas why? Thank you. Don
Take a look at this linkhttp://www.sqlteam.com/item.asp?ItemID=11672 and stop using maintenance plans as they tend to be flaky at times. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Sounds good enough for me. Thank you for the advice.