I use an SQL query to get the info SELECT VOLHISTORY.VOLUME_NAME, BACKUPSETS.BACKUPSET_NAME,BACKUPSETS.DATE_TIME, BACKUPSETS.DESCRIPTION FROM VOLHISTORY,BACKUPSETS WHERE VOLHISTORY.TYPE='BACKUPSET' AND VOLHISTORY.DATE_TIME=BACKUPSETS.DATE_TIME ORDER BY BACKUPSETS.DATE_TIME DESC
Give that a try! Chris Thomas Denier <[EMAIL PROTECTED]> on 10/05/2006 06:09:52 Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To: ADSM-L@VM.MARIST.EDU cc: (bcc: Chris Pasztor/HCS) Subject: Re: [ADSM-L] Media in a backup set? ----- Nick Laflamme wrote: ----- >Is there an easy way to figure out which media go with which backup >sets (and in which order?), or do I have to be really rigorous about >culling the information from the server logs? I can see from Q LIBVOL >which media are backupset media, but I don't yet see a way to see >which tapes go with each other. The 'query volhistory' command and the 'volhistory' SQL table will provide this information, albeit in a somewhat clumsy way.