Forum Discussion

mbjoe's avatar
mbjoe
Level 4
14 years ago

Export Selection Lists in Backup Exec 2010 R2

We are running Backup Exec 2010 R2 and I'm looking for a way to export the selection lists, is this possible? I need to create a database of the folders/files we backup for each job and figured exp...
Backup and Recovery
Backup Exec
Features
Reporting
Uninstall
  • RahulG's avatar
    RahulG
    14 years ago
    To query the Backup Exec Database (BEDB) and to export the backup selection lists to an external Microsoft Excel Spreadsheet, perform the following steps:
     
    1) Confirm that Microsoft Office Excel is installed on the media server.
    2) Open the Excel application.
    3) Click on the Data Menu.
    4) Click on "from other sources"  then select "From SQL Server".  The Data Connection Wizard then opens up.
    5) Enter the server name: BackupExecMediaServerName\BKUPEXEC
    6) Select the log on credentials to "Use Windows Authentication" and click "Next".
    7) Select the BEDB database.
    8) Check the option "connect to a specific table".
    9) Select the following view: "vwScriptPropertiesBackup".
    10) Click finish on the "Save data connection file and finish" Window.
    11) Click OK in the "import data" window.  This opens the Excel sheet with all the details.  "ScriptName" list the names of all the jobs including backup jobs.
    14) The ScriptName column can be sorted by the DeviceSelectionName, PathName and FileName to list the selection details for folders and file level detail.
     
    Note:  Excel must have access to SQL Database ODBC Driversfor the procedure above to be successful.  These steps also only access the database as read-only, hence the database is not changed or altered in any way.