Thanks for the suggestion.

However, from my understanding, MS-SQL TDP backup processing actually 
uses/honors the ManagementClass values specified for the node, while 
Oracle is a different animal and IT controls what is expired.





Schaub Joachim Paul ABX-SECE-ZH <joachim.schaub AT ABRAXAS DOT CH>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/20/2004 09:05 AM
Please respond to "ADSM: Dist Stor Manager"

 
        To:     ADSM-L AT VM.MARIST DOT EDU
        cc: 
        Subject:        AW: Flushing out old TDP SQL backups


for the TDP Oracle it has an executable namend TDPSYNC with the Parm 
SYNCDB
to eliminate garbage like this.
maybe it also exist for the SQL Agent?

regards
joachim

-----Ursprüngliche Nachricht-----
Von: Zoltan Forray/AC/VCU [mailto:zforray AT VCU DOT EDU]
Gesendet: Dienstag, 20. Januar 2004 14:56
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Flushing out old TDP SQL backups


I goofed and forgot to set DELETE BACKUPS = YES on a TDP SQL client (now
corrected)

So now, there are 1/2 Terrabyte of garbage SQL backups.

How do I get rid of them ?

I was hoping that EXPIRE INVENTORY would clear them out since I corrected
the setting, but it has not.