How-to Export a Selection List in Backup Exec

Posted on January 23, 2009 10:10 PM

To export a selection list in Backup Exec – edit job, select Submit, copy and paste.  This will give you a nice text version suitable for saving, searching, etc.  Portions of this can be copied and pasted back into the text view of the selection list.

The selection lists are accessible in the SQL server in the BEDB database in the vwScriptPropertiesBackup view.  The fields of interest are ScriptName, ScriptDescription, DeviceSelectionName, PathName, and FileName. A SQL command like this could be used to list these fields.

SELECT [ScriptName]
      ,[ScriptDescription]
      ,[DeviceSelectionName]
      ,[PathName]
      ,[FileName]
  FROM [BEDB].[dbo].[vwScriptPropertiesBackup]

You could set up a DSN and access this with Excel, or use the sqlcmd from the command line.  Adding a WITH clause to select a particular selection list could be useful also.

UPDATE:  This is not applicable to BackupExec 2010.  Instead, you can go to the Job Setup tab, find the selection list, right click "View Summary", and then highlight and copy the text from the window that pops up.

Related Posts

Comments

Comment by Giuliano

October 26, 2009 8:41 AM

Good info, thank you.

Comment by Mikael Bäckström

June 21, 2010 6:34 AM

Excellent information. I have written a few scripts myself to actually pick out data from the BE database for quality ensurance of backup, for migration and other things and the "Resources" have always been a big problem for me to piece together.

A simpler way to transfer the information is to simply install the "Copy Server configuration" module from the installation media (i always do this myself on new installations regardless if i use it or not, so i have actually not verified that it´s necessary). Then at the selection list, simply right click on it, select "Copy..." and then simply pick "Copy to other media server" and provide the servername and login for that media server.

This process also works perfectly for policies and jobs, making the BEMIG tool that many people get stuck while using, useless... unless you are actually requierd to export ADAMM information.

Catalogs can actually be transfered to a new Media server without transfering the entire database, but as stated above, you then loose the Cataloged information in your ADAMM database and are probably required to do an inventory and recataloging of the tape before you do the actual restore.

All in all tho, considering how much trouble it still is to use the BEMIG tool to migrate data from one installation to another, it can still be worth considering this "simpler" way to migrate to a new Media Server.

Comment by Stefan K.

August 25, 2011 4:46 AM

Thanks for the hint! (structure for selections is still the same in BE 2010 R3)

I think it's important to add the fields [OperType] and [IncludeSubdirs].
OperType defines if the Path in PathName is excluded (0) or included (1).

Bye,
Stefan

Comment by Gavin

February 20, 2012 10:13 AM

Thanks

Add Comment





[b][/b] - [i][/i] - [u][/u]- [quote][/quote]