I use the follwoing statement in excel to return the volumehistory information tied to the backupset information. Notice it is keyed off of the date and time so it is possible (although rare) to get some invalid information.
SELECT VOLHISTORY.VOLUME_NAME, BACKUPSETS.NODE_NAME, BACKUPSETS.BACKUPSET_NAME, BACKUPSETS.DATE_TIME, BACKUPSETS.RETENTION, VOLHISTORY.TYPE, VOLHISTORY.COMMAND FROM BACKUPSETS BACKUPSETS, VOLHISTORY VOLHISTORY WHERE BACKUPSETS.DATE_TIME = VOLHISTORY.DATE_TIME "Coats, Jack" <[EMAIL PROTECTED]> on 09/19/2002 02:32:34 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: Joseph Pendergast/Corona/Watson) Subject: How can I tell what tapes are in a BackupSet? Anyone have a suggestion for a select statement that could return this a list of the tapes in each BackupSet that is still active?
