I haven't done this myself, but I'd hazard a guess that if there's no standard way of doing it from the TDPSQL GUI (I don't have it in front of me, but I don't recall that there is...) the standard TSM BA Client might be a useful place to take a look if it's possible (configured to use the TDPSQL nodename of course) - we've done it in the past to achieve similar recoveries of Oracle archived redo logs outside of TDP for Oracle/RMAN.
/David Mc London, UK -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Zoltan Forray/AC/VCU Sent: 08 October 2009 13:11 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] MS-SQL TDP log restore question My MS-SQL guy has the following question and was hoping some TDP experts can give us an answer, one way or the other: "We have an issue that may require physically looking through an old transaction log backup to see if we can find out some information about who is doing what in the database. However, since the TDP client takes the backups straight off to TSM, I'm not sure how to do that. Is there a way we can pull those transaction log backups out of TSM and put them on the server as a file as opposed to doing a restore? " No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.420 / Virus Database: 270.14.3/2415 - Release Date: 10/06/09 18:34:00
