Re: Determining what has been backed up
1999-03-17 07:43:05
Subject: |
Re: Determining what has been backed up |
From: |
Dwight Cook <decook AT AMOCO DOT COM> |
Date: |
Wed, 17 Mar 1999 06:43:05 -0600 |
select * from adsm.backups where
(cast((current_timestamp-backup_date)day as decimal(18,0))<2)
This should give you a real loooong list of everything from the last
24-48 hrs depending on what time you run it...
add a
and node_name='WXYZ'
on the end if you desire
later,
Dwight
______________________________ Reply Separator _________________________________
Subject: Determining what has been backed up
Author: anthony.doig (anthony.doig AT OPENTECH.CO DOT NZ) at unix,mime
Date: 3/16/99 9:56 PM
G'day,
[ potentially dumb question - I've poked around myself but cannot find the
answer ]
I would like to determine what files and directories were backed up for a
particular client backup session. I can run the "query actlog
originator=client ..." command and get detailed statistics on backup
sessions, but I want to know what files were processed by each client
session. I could run a SQL query to find what was backed up for a particular
session/node between the start/end times for each client session, but this
would not work if a client has multiple sessions running ...
Is this possible at the server end, or would I need to go and look at log
files at the client ?? I would rather handle it all at the server.
The client session could be started either via the ADSM scheduler or
externaly/manually from the client end.
I'm using an ADSM v3.1.1.0 server on HP/UX 10.20 and an ADSM v3.1.0.3 server
on NT v4.0 (NT/UNIX clients).
Cheers and thanks in advance,
Anthony
--
Anthony Doig
Anthony Doig
Professional Services Consultant
Open Technology Ltd
Wellington, New Zealand
Phone :+64 4 385 2969
Fax :+64 4 385 7764
Mobile:+64 21 632 062
mailto:anthony AT opentech.co DOT nz
http://www.opentech.co.nz
|
|
|