Forum Discussion

JWilly's avatar
JWilly
Level 2
16 years ago
Solved

Changing selection list daily

We have a packaged application that uses SQL to store it's data.  Every day, a new SQL database is created and an old one is deleted.  The vendors of the application require us to manually every day go into Backup Exec and deselect the oldest SQL database and select the newest one.  A similar routine is done to a data folder as well.  We HAVE to follow their procedures.  Instead of getting into the "why's" and "that's stupids", is there a way to accomplish this automatically rather than manually doing this every day.  If something like this is scriptable, please point me in the right direction.  If there's an add-on that might do this, please point it out to me.
  • Yes you can do this.  You can create a selection list on the fly with a command line scripting utility included with bews.

    The utility is at %programfiles%\symantec\backup exec\bemcmd.exe

    Here is an example syntax to create a selection list
    bemcmd -o220 -s<name of selection list> -f<script file>
    bemcmd -o220 -s"Test Selection List" -f"c:\test.txt"

    The script file must have a syntax similar to the following
    [Selections]
    SQL1=<servername>\<sql instance>

    You can find more information about the options for the script file here exftpp.symantec.com/pub/support/products/Backup_Exec_for_WindowsNT/BeAdmin85_233420.pdf starting on pg 402.

2 Replies

  • Yes you can do this.  You can create a selection list on the fly with a command line scripting utility included with bews.

    The utility is at %programfiles%\symantec\backup exec\bemcmd.exe

    Here is an example syntax to create a selection list
    bemcmd -o220 -s<name of selection list> -f<script file>
    bemcmd -o220 -s"Test Selection List" -f"c:\test.txt"

    The script file must have a syntax similar to the following
    [Selections]
    SQL1=<servername>\<sql instance>

    You can find more information about the options for the script file here exftpp.symantec.com/pub/support/products/Backup_Exec_for_WindowsNT/BeAdmin85_233420.pdf starting on pg 402.