Solved

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

Posted on 2010-09-09
7
917 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Powershell v3 - SQLCMD 3 27
CDC and AOG on MS SQL 2012 13 25
Acces SQL Insert Problem 6 32
Use column to search string column 2 11
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

831 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