Why not just do a bpflist on the backupid
to determine what files it had?
What I typically do is:
bpimmedia -L -policy <POLICY>
-d mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy hh:mm:ss
where -d = start time and -e = end time of
the backup you're interested in.
Or use bpimagelist:
bpimagelist -L -policy <POLICY> -d
mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy hh:mm:ss
You can pipe that through “grep
<hostname>_” to get just the backupids for the backup.
You can then run a bpflist on those images
to see which files were backed up:
bpflist -backupid <backupid from
above> -d mm/dd/ccyy hh:mm:ss -e mm/dd/ccyy -rl 999
NOTE: If client/media server is not
the master then add "-client <clientname>".
From:
veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Stump, Bob A
Sent: Friday, February 27, 2009
1:47 PM
To:
veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] locate
database files in clients system level backups
Hello,
I have a thousand clients on several sites
throughout the U.S.
I want to be able to determine if a client has a database on it that is getting
copied to tape by a NetBackup system level backup. I thought that perhaps I
could use the NetBackup image catalog. I was thinking that I could
uncompress and convert the clients image files to ascii using
bpcatlist/cat_convert and search for .dbf, .mdf, .ldf etc… in the files.
Has anybody done this that could help me get started?
Thanks,
Bob Stump
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not
disclose,
distribute or use the message in any manner; and (iii) notify the sender
immediately. In addition,
please be aware that any message addressed to our domain is subject to
archiving and review by
persons other than the intended recipient. Thank you.
_____________