transition logs not purging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JR - 25 Feb 2005 22:51 GMT

I am running sql 2000. I am setting up maintenance jobs to backup databases
and transition logs for a certain amount of days. The database logs are
backing up fine and purging the old backup files. However the transition logs
are backing up but not purging the old files. Any ideas?

Reply to this Message

Mike Epprecht \(SQL MVP\) - 26 Feb 2005 14:14 GMT

On the maintenance plan, for the transaction logs, is the setting "remove
files older than" set?

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> I am running sql 2000. I am setting up maintenance jobs to backup databases
> and transition logs for a certain amount of days. The database logs are
> backing up fine and purging the old backup files. However the transition logs
> are backing up but not purging the old files. Any ideas?

Reply to this Message