Backup Exec 11d - Which Table Holds Backup Set Information

Posted on 2009-02-10
Last Modified: 2013-12-01
I need to query the BEDB to produce a list of the Backup Sets by Machine or Job Name.  Of the 146 tables in the BEDB, does anyone know which table contains the backup set information?
Question by:robtroller

    Author Comment

    I believe that the CatResource table has this information.  Does anyone know if this is the information that represents the selection list data?

    Author Comment

    OK, looking further into this, the CatResource table and the Resource table both contain the server name and the each of the drives that are being backed up.  The Resource table also contains any SQL db being backed up.  Unfortunately, I 'm not able to find the Selection Detail.  For instance, if I have selected only the Documents and Settings and Windows directories on the C drive, I can query and get the server name and C as a resource but I'm still not able to find the two directories that are being backed up.  Anyone know where that bit of data resides?
    LVL 28

    Expert Comment

    Check the resource table

    Accepted Solution

    After more reverse engineering I came up with the following:
    The backup set data is housed in the BackupScriptEntries table.  The script name (Selection List Name) that ties the backup set selections together is found in the Scripts table.  The attached query will pull the Selection List Name, the File Path and a delimiter that indicates if the file path is Excluded (1 = /SUBDIR  0=/SUBDIR /EXCLUDED).  You must provide the ScriptID parameter to the query (@Param1).  The ScriptID can be found in the Scripts table and in the Jobs table. It is easy to find the specific Job Name in the Jobs Table then plug the ScriptID in to this query and come up with the Backup Set details.
    Hope this is helpful.

    Select s.Scriptname as "SL", b.deviceselectionname + b.pathname  + '\'  + b.[filename] as "BS", OperType as "Ex"
    from [nebackup01\bkupexec].bedb.dbo.Scripts S join [nebackup01\bkupexec].bedb.dbo.BackupScriptEntries B  
    on s.scriptid = b.scriptid
    where s.ScriptID =  @Param1 and delimiter <> 1
    order by b.deviceselectionname

    Open in new window


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    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.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    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…
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    732 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

    21 Experts available now in Live!

    Get 1:1 Help Now