My understanding:

SQL databases deleted from the SQL instance are not inactivated
automatically. You will need to do this manually from command line
interface via he TDPSQLC INACTIVATE. Or via the GUI, Select "View",
"Inactivate Tab" and a tab is shown that allows you to choose the
database backup(s) to inactivate.

That's the way i've always done it.

Hope this helps


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stefan Holzwarth
Sent: 05 March 2008 10:01
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TDP SQL - cleanup of deleted databases

We are useing TDP SQL for MS SQL2005 and have setup our policies.
One example:
                Policy Domain Name: TDP
                   Policy Set Name: STANDARD
                   Mgmt Class Name: SQLDBDATAOBJECTS
                   Copy Group Name: STANDARD
                   Copy Group Type: Backup
              Versions Data Exists: No Limit
             Versions Data Deleted: No Limit
             Retain Extra Versions: 30
               Retain Only Version: 60
                         Copy Mode: Modified
                Copy Serialization: Shared Static

I'm not clear about the following thing:
If we delete a db withing the sql instance does it disappear after 60
days? (as files and directories do with baclient)
Or - do we have to manually inactivate the last active backup of a
database, that has been allready deleted from MS SQL. 
(we do our sql backups with target=*)

Regards
Stefan Holzwarth
------------------------------------------------------------------------
--------------
Email scanned for viruses and spam by the Woolworths
anti-virus systems.

If you believe this email is spam, please forward to
suspectspam AT woolworths.co DOT uk
****************************************************************************
Woolworths plc
Registered Office: Woolworth House, 242/246 Marylebone Road, London NW1 6JL 
Registered in England, Number 104206

This e-mail is only intended for the person(s) to whom it is addressed and 
may contain confidential information.  Unless stated to the contrary, any 
opinions or comments are personal to the writer and do not represent the 
official view of the company.  If you have received this e-mail in error, 
please notify us immediately by reply e-mail and then delete this message 
from your system. Please do not copy it or use it for any purposes,  or 
disclose its contents to any other person.  Thank you for your co-operation.
****************************************************************************
------------------------------------------------------------------------------------
Email scanned for viruses and unwanted content by emailsystems

Information regarding this service can be found at www.emailsystems.com