>3) We have a collection of old management classes laying around that I
>would like to get rid of.  Is there an easy way to tell whether any client
>data is still being stored under these management classes?  I was thinking
>of "query occupancy" but that doesn't seem to have what I need.  Is there a
>"select" statement I could issue that will tell me?

There is a field name CLASS_NAME in the BACKUPS and ARCHIVES tables,

SELECT * FROM BACKUPS WHERE CLASS_NAME='MYCLASS_NAME'

I think this will run for hours and hours.

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Reply via email to