Hello, Laura -
Andy said it best (and most definitively). Some details and thoughts...
The FILESPACES table contains the datestamp for when an unqualified
Incremental backup completed. The details of what was backed up is
contained in the client schedule log. Auditors may require retention
of these logs. This is the detailed verification of backup.
The server BACKUPS table stores information about when each file
system object was backed up, including when. This represents a server-
side, queryable catalog of backed up files. It does not contain
volume information: that is in the CONTENTS table (which is arduous
to query). Neither table contains storage pool name info: a join
with the Volumes table would be necessary (which adds to processing
overhead).
If you know from the backup that the file got to TSM storage, then
the Activity Log evidence of a successful Backup Stgpool (or Preview)
on its destination stgpool is the quickest way to verify that the
files are indeed in the offsite stgpool. You can further verify this
via an extension of your suggestion to the auditors by temporarily
marking the primary storage pool and any used onsite copy storage
pool as Unavailable and then attempt a Restore, which would evidence
if the file was in the offsite pool.
You can get a list of your offsite volumes and when last written, for
a given node and filespace, via like:
select VOLUME_NAME, LAST_WRITE_DATE from VOLUMES where VOLUME_NAME in -
(select VOLUME_NAME from volumeusage where node_name='HOST05' AND
FILESPACE_NAME='/users' AND STGPOOL_NAME='STGP_BACKUP_OFFSITE')
For a given primary stgpool volume, you can use the Query CONTent
command with COPied=Yes to verify if its contents are in a copy
storage pool (any copy pool).
hope that helps, Richard Sims
On Jun 16, 2006, at 10:37 AM, Laura Mastandrea wrote:
Thank you!
Okay, back to the query can I just get information the this node
was backed
up on this data to the offsite storage pool successfull? Giving
them the
information that the schedule completed successfully isn't enough.
I've suggested to the auditors that we recover the file if they
truly want
proof.
Laura
|
