My knowledge of select statements is fairly limited but you will probably have to use the information in the BACKUPS table but I am unsure how to figure out which tape the file is stored on. My guess is to use the OBJECT_ID field and there must be another table that stores what tape that OBJECT_ID is on.
Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/07/02 02:53AM >>> Julian, I have been having a look at using your select statement below and with slight modifications I am getting the number of tapes that are needed for each filespace for the particular node. I believe that the results brought back by this select command are effectively any tape which has a file from the particular filespace, whether it be an active copy or an inactive copy. I tested this by running the statement against a filespace on a node and it came back with a list of 7 tapes that would be needed. I then performed a selective backup of that filespace and allowed the overnight processing to do its stuff (updating all the offsite pools). Checking the results this morning instead of just having one tape returned, 8 tapes were listed. My question to you or anyone out there who knows more about select statements than me (a lot of people I reckon) is: Is there a select statement that would bring back a list of tapes that would be needed to restore a particular filespace for a node that only takes into account the active files needed? Thanks in advance Steve Copper -----Original Message----- From: Julian Armendariz [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 14:56 To: [EMAIL PROTECTED] Subject: Re: how to identify ofsite tapes for specific node This email and any files transmitted have been checked by the MessageLabs Virus Scanning Service for the presence of computer viruses. Please exercise caution when receiving any attachment(s) from unknown sources. If in any doubt, do not open any attachment and delete the message immediately. Thank you for your co-operation. _________________________________________________________________ I use this SQL script to get the volumes used by a specific node in a specific storagepool. select distinct node_name,volume_name from volumeusage where node_name=upper('$1') and stgpool_name=upper('$2') You can either run this from a command line and replace the $1 with the node name and $2 with the storage pool or add the script to the server and type "run name_of_script nodename storagepool". You can type the names either upper or lower case. Julian Armendariz System Support Analyst - UNIX H.B. Fuller >>> [EMAIL PROTECTED] 03/04/02 09:39PM >>> hi guys, please help me to identify offsite tapes belong to a specific node. i have a problem on my onsite tapes for specific node but i could not easily identify which offsite tapes belong to that node from my offsite location. Do you have a SQL scripts or commands to get done this tasks? your help is really appreciated..... thanks, Zosi Noriega ADNOC - UAE _________________________________________________________________ This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this message has been swept for all known viruses by the MessageLabs Virus Scanning Service. For further information please visit http://www.messagelabs.com