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-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Stump, Bob A Sent: Friday, February 27, 2009 1:47 PM To: veritas-bu@mailman.eng.auburn.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. _____________ Please consider our environment before printing this e-mail or attachments. ---------------------------------- CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you. ----------------------------------
_______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
