Running Win 2k & SQL 2k

I am not sure if this is a bug or by design, but in my Database
Maintenance Plans, on the Transaction Log Backup tab, I have the
'remove files older than:' checked, with a value of 2 weeks, but my
TLogs do not delete automatically.

Is this by design or a bug??


AHIA,
Larry...

They should be getting deleted.

Two things to check:

1. Make sure the account the sql server agent runs as has permissions to
delete the backup files

2. The old backup files are deleted by the agent "after" the next time the
agent backups the log following the old backups expiration. If the backup
task fails to backup any of the transaction logs its scheduled to backup, the
agent will fail and the old backups will not be deleted. So for example if
the maintenance plan applies to db1 and db2, it must sucessfully backup the
log for both db1 and db2, before it will try to delete the log backups for
either database older than the 2 weeks you have specified.

J.T.


[quoted text, click to view]