Just went through the same problem.

If your SQL backups are under a mgmt class that you can't change the RetOnly
and/or VerDelete options without effecting other servers.  You will have to
change the filespace name the SQL agent uses to backup under.  Then after
using the new filespace for a while, you can remove the old filespaces.

Anthony Jones
ADSM Administrator
Koch Industries, Inc.


> -----Original Message-----
> From: Chris Zaremba [SMTP:zaremba AT US.IBM DOT COM]
> Sent: Wednesday, January 27, 1999 8:23 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: SQL reclaim
>
> Leo,
>
> >I noticed that when I delete database backups with the ADSM SQLagent and
> run expire >inventory. The reclamation for the SQL volume remains at 0%.
> Expire inventory also runs >daily and I can reclaim tapes containing ADSM
> backup client data.
> >Am I missing something ?
>
>
> What is the value of the VERDELETED copygroup parameter in the management
> class used
> by the SQL Agent?  It must be set to 0 to allow objects deleted through
> the
> agent to
> be expired the next time the ADSM server does its expiration processing.
>
>
> Chris Zaremba
> ADSM Agent Development
> internet  zaremba AT us.ibm DOT com