I had the same question a couple of days ago, because I needed to restore a password file from at least three weeks ago. (the date the system administrator left suddenly). Luckily for me, the guy deleted the file on the server and so the restore grabbed the latest copy in it's archive.
Ideally, I wanted to be able to get the file that was from the day before he left and restore it. But I couldn't figure it out. If the guy had just corrupted the password file then I would have been hosed. Because the restore would have restored a backup of a corrupted file. Kerry -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Friday, December 29, 2006 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select statemant to find oldest file in diskpool I don't see any way to get that. The TSM server stores the backup date of a file in the BACKUPS table. But there is no pointer to tell you which storage pool volume that particular file is in. WHY are you trying to get the information? Perhaps there is another way. If you have the file name, just pull it from the backups table... -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gary Osullivan Sent: Friday, December 29, 2006 11:30 AM To: ADSM-L@VM.MARIST.EDU Subject: select statemant to find oldest file in diskpool hi all I'm trying to come up with an sql to select the file dates in a specific stgpool What I really need to find is the oldest date stamp of a file in a specific onsite disk pool any help would be great Gary *** CONFIDENTIALITY NOTICE*** This message and any included attachments are from MedSynergies, Inc. and are intended only for the addressee. The contents in this message contain confidential information belonging to the sender that is legally protected. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or contact MedSynergies, Inc. at [EMAIL PROTECTED]