Use the following select statement:

select * from backupsets, volhistory where backupsets.date_time =
volhistory.date_time

Joerg Pohlmann
604-535-0452





Kevin Godfrey <kevingodfrey AT CATHS.CO DOT UK>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-02-03 07:41
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Backupset



Hi

How can one see which volumes belong to a particular backupset?

Thanks

Kevin