ADSM-L

Re: SQL reclaim

1999-01-27 21:37:00
Subject: Re: SQL reclaim
From: Jones, Anthony <Jones4A AT KOCHIND DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU <ADSM-L AT VM.MARIST DOT EDU>
Date: Thursday, January 28, 1999 2:37 AM
>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
<Prev in Thread] Current Thread [Next in Thread>