Roger Deschner wrote: > This is always a puzzle, and the best I've come up with is the backup > completion timestamps for each filespace, as reported by either: > > * Linemode Client QUERY FILESPACE command (This valuable information is > not available in the GUI client - why?) > > * Server Q FILESPACE F=D. I have written a script to make this easier to > look at. (below) > > This is still imperfect, because if you do a partial backup using the > GUI client, and choose only some directories within a filespace, then > the filespace backup completion timestamp does NOT get updated, even > though the SUMMARY table will show success for such a partial backup. > There are other ways this filespace backup completion data can be an > imprefect indicator of the success or failure of a backup. Nevertheless, > these filespace backup completion timestamps are the most reliable thing > available to tell whether or not the backup really worked. > > Here's the script I use: (v5.5 server) > /* Script QBACK */ > /* Q FILESPACE with dates showing */ > /* Argument may be lower or upper case */ > /* 2007-11-14 - Roger Deschner, University of Illinois at Chicago */ > set sqldisplaymode wide > select - > CAST(filespace_id AS CHAR(2)) AS "ID", - > CAST(filespace_name AS CHAR(40)) AS "FS Name", - > CAST(filespace_type AS CHAR(8)) AS "FS Type", - > CAST(SUBSTRING(CAST(backup_start AS CHAR(26)) FROM 1 FOR 16) AS CHAR(16)) AS > "Started", - > CAST(SUBSTRING(CAST(backup_end AS CHAR(26)) FROM 1 FOR 16) AS CHAR(16)) AS > "Ended" - > from adsm.filespaces where node_name=UPPER('$1') ORDER BY 5 DESC > > Roger Deschner University of Illinois at Chicago rogerd < at > > uic.edu > ======I have not lost my mind -- it is backed up on tape somewhere.===== > > >
Thank you all for your excellent help. Right now I went the easy way and just did a: SELECT ACTIVITY,NUMBER,SUCCESSFULL FROM SUMMARY WHERE ENTITY='node_name' But at the same time I also verify that the filer reports the backup / restore as successful. I'll also look into the other points mentioned by you, but for now this solution is fine for me. Regards, Jan +---------------------------------------------------------------------- |This was sent by m...@janseidel.net via Backup Central. |Forward SPAM to ab...@backupcentral.com. +----------------------------------------------------------------------