I generate a report once a month that shows me all the filesystems that
have not been backed up in more than 30 days. I can look through the
list and pick out the hosts that I know should be backing up.
Here is the select statement I use (likely borrowed from this forum).
select node_name, Filespace_name,
(current_timestamp-backup_end)days as "days_since_backup" from
filespaces where
cast((current_timestamp-backup_start) days as decimal) >=30 order
by "days_since_backup"
Ben
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Jeremy Cloward
Sent: Friday, November 10, 2006 11:36 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Days Since Last Access
Yeah, I am in the same boat,
I have too many nodes that do not backup, anbd no way to know unless I
look in the failure report that gets e mailed out. Best thing to do is
check the filesystem and see the last time It was accessed and backed
up, the hitting the server info means meta data was sent and the system
said yeah Im here, its the filesystem that tells you what is really
going on.
Jeremy
Friday, November 10, 2006 1:32 PM
To: ADSM-L AT VM.MARIST DOT EDU
cc:
From: "Kauffman, Tom" <KauffmanT AT NIBCO DOT COM>
Subject: Re: [ADSM-L] Days Since Last Access
We had a system that was connecting to the server 4 times a day, so last
access was always less than 1. I crashed and burned, got rebuilt -- and
the most recent backup was 15 months old.
And I *still* can't get the NT admins to check the logs on any regular
basis.
Tom Kauffman
NIBCO, Inc
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Prather, Wanda
Sent: Friday, November 10, 2006 12:17 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Days Since Last Access
"Days since last access" just tells you the last time there was
communication between the client and the server.
It doesn't tell you anything about whether the client was backed up, or
not.
The communication could have been a single restore; or it could be the
client scheduler just checking for a backup time.
Or you could have a client backup that started, but did not complete
successfully.
To verify whether the client has been successfully backed up, look at
q filespace nodename f=d
Look for the "last backup end" date for each client filesystem to see
when it last backed up.
Wanda Prather
"I/O, I/O, It's all about I/O" -(me)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Avy Wong
Sent: Friday, November 10, 2006 11:52 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Days Since Last Access
hello,
When I do a q node to find out what nodes are being backed up, I see
that "<1" means it is being backed up properly. But at times I see "1" ,
"2", "3" ......" some big number " without "<" attached to it , my
question is what is the definitive number to say it is still being
backed up without digging through the details I have been told that "1"
.. up to "3" is still ok. Thank you for clarifying.
Node Name Platform Policy Domain Days Since
Days Since Locked?
Name
Last Access
Password
Set
------------------------- -------- --------------
---------- --------- -------
DAT03TEST WinNT STANDARD <1
235 No
EOSNOTE1 WinNT STANDARD 1
240 No
ESSMOC04 WinNT STANDARD 653
855 No
Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
ext 28164
************************************************************************
**************************
The information contained in this message may be privileged and
confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you
are hereby notified that any dissemination, distribution, or copy of
this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer.
************************************************************************
**************************
CONFIDENTIALITY NOTICE: This email and any attachments are for the
exclusive and confidential use of the intended recipient. If you are
not the intended recipient, please do not read, distribute or take
action in reliance upon this message. If you have received this in
error, please notify us immediately by return email and promptly delete
this message and its attachments from your computer system. We do not
waive attorney-client or work product privilege by the transmission of
this message.
|