>From the 'volumeuseage' table, you can identify which offsite tapes contain the data for that node. However, as i understand it, you cannot determine which have the latest backups on them.
We done this last week for a node, identified 43 offsite LTO3 tapes that had the data for a node, then manually loaded them into the offsite library, ran the restore to the latest versions (13 million files) and let it run. Takes a while, but it's the only way i know Jeff -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Davis, Adrian Sent: 03 March 2008 09:18 To: [email protected] Subject: [ADSM-L] Is it possible to get list of OFFSITE tapes to restore node to latest backup? Is it possible to get a list of the OFFSITE tapes required to restore a specified node to the *latest* backup? Many Thanks, =Adrian= Adrian Davis * System Administrator * SunGard Public Sector Ltd * (Unit 72) 1st Floor, Romer House, 132 Lewisham High Street, Lewisham, London, SE13 6JG, UK * Tel +44 (0)20 8463 8571 (DDI) * www.sungardps.co.uk ------------------------------------------------------------------------ -------------- Email scanned for viruses and spam by the Woolworths anti-virus systems. If you believe this email is spam, please forward to [EMAIL PROTECTED] **************************************************************************** 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
