Solved

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

Posted on 2010-09-09
7
915 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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…

863 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now