Solved

Query Backup Exec 12.5 to see which tapes are used for specific day

Posted on 2010-09-09
7
916 Views
Last Modified: 2012-05-10
I am new to backup exec adn trying to figure some things out.
Currently running Backup exec 12.5 winth mssql on windows 2003 r2 box.

I want to query the bedb to be able to find which tapes are used on which days for each month.
does anyone know what table and or fields are used to get the daily tape information ?

the goal is to link this to an excel sheet and be able to select a day, a month, from a drop down
and have it pull up which tapes where used for that nights backup.

any help would be greatly appreciated.
0
Comment
Question by:mndthegap1
  • 4
  • 2
7 Comments
 
LVL 7

Expert Comment

by:oztrodamus
ID: 33643722
Your B/E logs tell you the name of the media used for that job. When you fist insert a tape B/E will auto assign a name to the tape. I would relabel your media so it's more meaningful. Also, if you have an autoloader you can partition it so the same tape is always used for a particular day. I do this for my Mon - Thurs tapes and rotate out my Friday Weeklys.
0
 

Author Comment

by:mndthegap1
ID: 33646664
thanks for the information, that actuallty helps with another issue. but what we change tapes each week. basically we have 6 tapes for the 1st monday of first week of month, 6 tapes for 2nd monday of 2nd week of month, and so on for each day.  so basically i would have to create a partition for each day of the month ?

but as for the excell sheet, we keep a writen log of the tapes used and i was just trying to automate this a little bit by pullling the info from the execdb.

i tried the following:

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=BEDB;Data Source=libackup01\BKUPEXEC;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=MK00425;Use Encryption for Data=False;Tag with column collation when possible=False


this sort of works BUT if a tape is pulled for the nightly jobs say next morning, it will show up under that day not the night before.  i was looking to see if i can query when tapes are imported and exported.
It seems as thought there is not an entry in a table for that, since it only shows up on the xml file for the job history.

any help would be great.  also if you can explain your above aswell that would be much appreciated since that was something else i was looking into.

thanks again for all your help thus far i appreciate the info.
0
 
LVL 7

Expert Comment

by:denbosse
ID: 33652440
Why not write a script that parses the XML of a job log (found in the data subfolder). That XML contains information about the name of the job (<name> tag), the start date/time (<start_time> tag) and the tapes used (<media_label> tag).
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:mndthegap1
ID: 33662104
that sounds like an excellent idea, but im not sure how to do that.
do you have a website or something that i can reference to write a script for that ?
0
 

Author Comment

by:mndthegap1
ID: 33662197
the other issue i have is the xml files change daily.
i would also need to specify only the import/export job history
0
 
LVL 7

Accepted Solution

by:
denbosse earned 500 total points
ID: 33667192
I don't have an example, but some of these links may get you started:
http://msdn.microsoft.com/en-us/library/aa468547.aspx 
http://www.w3schools.com/Dom/dom_nodes_get.asp
http://www.devguru.com/technologies/xml_dom/15891.asp


You could list all the files in the directory with the FileSystemObject (FSO) and only get those with a modified date of yesterday for example: http://www.devx.com/tips/Tip/13807 

By opening only the files for a certain date range and then getting values friom inside the XML to identify Import/Export job, tapes and dates.
0
 

Author Comment

by:mndthegap1
ID: 33691866
the issue with above is there are approx 6-7 xml files created each day and i need to run this for each day. BUT only 2 are for the imported media. so it will still pull every xml doc in the folder.
i appreciate the help.

im going to see if there is anything i can do with each of those.
and see if i can do something with it.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question