We've been having trouble with our SQL 2000 Servers not deleting the .bak and log files. We've set default the retention periods on all of our maint. plans but sometimes they don 't get deleted... and .... no one checks them... disks get full... need I say more?
Is this a problem with corupt metadata? or is there a MS double-blind-secret-handshake that we need to know to make this work??
How can we fix this ??