Re: Find what tape a particular backup resides on

2006-03-22 Thread Joni Moyer
Hello, I have tried this command: select * from volumeusage where node_name='NAS_SERVER_2_OFFSITE' and have received the following output: NODE_NAME: NAS_SERVER_2_OFFSITE COPY_TYPE: BACKUP FILESPACE_NAME: / STGPOOL_NAME: TAPE_NDMP_OFFSITE VOLUME_NAME: N00020 FILESPACE_ID: 47 I g

Re: Find what tape a particular backup resides on

2006-03-22 Thread Choudarapu, Ramakrishna (GTI)
SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name' Regards, Rama -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, March 22, 2006 10:05 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Find what tape a particu