Because of this (we are just looking into backupsets), we have decided to
use the description area to denote node name and date. Then this can be
used to tie the volumes together. I could not come up with anything else
yet. I will be interested in what the rest of the group has to say.
--
Phillip Ford
Senior Software Specialist
Corporate Computer Center
Schering-Plough Corp.
(901) 320-4462
(901) 320-4856 FAX
[EMAIL PROTECTED]
-----Original Message-----
From: Brian T. Huntley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 9:00 AM
To: [EMAIL PROTECTED]
Subject: query backupset volumes
Hello all...
Does anyone know of an easy way to find out what tape volumes make up a
particular backupset, or backupsets from a particular node? So far, the
only thing I've been able to come up with is:
select volume_name from volhistory where command='<command used to create
backupset>'
There _must_ be an easier way to do this....
Any ideas?
TIA!
Regards,
Brian
+-----------------------------------------------------------------------+
| Brian T. Huntley Systems Administrator |
| Campus Information Services, Clarkson University |
| Ph/FAX: 315.268-6723/6570 |
| [EMAIL PROTECTED] www.clarkson.edu/cis |
+-----------------------------------------------------------------------+
UNIX *is* user friendly. It's just selective about who its friends are.
PGP Public Key available. finger [EMAIL PROTECTED]
