Thank you very much!!!!!
Laura
To
ADSM-L AT VM.MARIST DOT EDU
cc
From
Sent by
Richard Sims <rbs AT BU DOT EDU> on 06/16/2006 10:30 AM
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
Subject
Re: [ADSM-L] SQL SELECT Query
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
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
DISCLAIMER:
This communication, along with any documents, files or attachments, is intended
only for the use of the addressee and may contain legally privileged and
confidential information. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of any information
contained in or attached to this communication is strictly prohibited. If you
have received this message in error, please notify the sender immediately and
destroy the original communication and its attachments without reading,
printing or saving in any manner. This communication does not form any
contractual obligation on behalf of the sender or, the sender's employer, or
the employer's parent company, affiliates or subsidiaries.
|