Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get you started in the right direction. You basically need to name each file according to the date and then you can use xp_cmdshell to delete them when ready. ---------- Separate file for each day of the week ---------------- DECLARE @DBName NVARCHAR(50),...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/09/10/1963.aspx