Im having difficulty knowing where to specify the deletion period for the dump files created in a SQL2005 database backup schedule in SQL Agent. It seems now to create an SSIS sub-package for the task when using the wizard options, and doesnt seem to have the "remove after x days/weeks" option that the old SQL 2000 wizard used to have:
-UseDefDir -DelBkUps 1WEEKS -BkExt "BAK"'
On looking at the SQL2005 backup db subtask, it seems to call a cmd exec command;
/SQL "Maintenance Plans\MaintenancePlan - backup databases" /SERVER "$(ESCAPE_NONE(SRVR))" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false
Any ideas how you do this?