Sql 2000 Maintenance Plan not deleting old transaction logs

I created a maintenance plan using enterprise manager 8 for a sql server
2000 database. In regards to the transaction log, the maintenance plan is
configured to:

- backup the transaction log
- verify the backup's integrity
- use a non-default file system location for storage
- *remove files older than 1 day*
- use TRN as a file extension
- scheduled to run nightly

Everything works fine with one exception: the older transaction log backups
are not being deleted (those that are older than one day).

This same maintenance plan is also configured identically to backup the
database data, and in that case *is* deleting the older data backups. The
plan is also configured to run optimizations once a week on Sundays which
include reorganization and shrinking.

Obviously, I'd rather not have to delete these extra backup files manually
or with an extraneous script. However the setup and configuration of the
maintenance plan is very straight forward ... it simply appears not to work
(on the point of the transaction logs).

Our service packs are all up to date and I checked the maintenance plan
history log which contained entries like "Delete old db backup files" but
did not contain anything like "Delete old transaction backup files" ... so
what gives?

Any ideas are much apreciated!

TIA//


.

Relevant Pages

  • Re: Database Maintenance Plan Problems
    ... >may want to create separate maintenance plans for the system databases such ... Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan ... >A maintenance plan job to backup transaction logs may fail. ...
    (microsoft.public.sqlserver.server)
  • Re: Event log error message: Database log truncated: Database
    ... our maintenance plan combines both master and the User ... It also selects Transaction Log Backup option. ... back up the database as part of the maintenance plan and etc) ...
    (microsoft.public.sqlserver.server)
  • transaction logs too late to apply
    ... whilst after the full backup occurs. ... outlines the complete backup daily and hourly transaction log backup so I ... which is too late to apply to the database. ... I have now deleted the maintenance plan for the logshipping but it was a ...
    (microsoft.public.sqlserver.replication)
  • Re: Database transaction log keeps on growing
    ... Do you have performed a backup of the transaction log? ... But with your huge log file you probably will have a storage-space problem. ... it's absolutely necessarily to create a maintenance plan ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Mantanace Plan not deleting old files
    ... The problem I had was someone set up a maintenance plan to backup ALL ... > account is the security context for jobs, ... > and ensure the SQLServerAgent startup account has Full Control. ...
    (microsoft.public.sqlserver.server)