Re: Defining Schedules with Options

No, that will not get you what you want, and it won't even function.

The OBJECTS field represents the things you want to back up. exclude and
include statements are not items to be backed up, so the syntax will fail.
Also, you can not specify include and exclude statements from the command
line, so doing so from a schedule is not valid, either.

1) The include statements should be in the client options file (or in a
client options set if you wish to control these from the server):

   include e:\sqlbackups\db1\*.bak FULLBACKUPS
   include e:\sqlbackups\db2\*.bak DIFFBACKUPS
   * .....\db1\...\*.bak to traverse subdirectories, if that is desired
   * .....\db2\...\*.bak to traverse subdirectories, if that is desired

2) The schedule definition could then be:

def schedule standard once_a_day_schedule type=client
   desc="Daily backup of SQL backups"
   action=Incremental
   objects="e:\sqlbackups\db1\*.bak e:\sqlbackups\db2\*.bak"
   startdate=04/10/2003 starttime=00:30
   duration=12 durunits=hours period=1 perunits=days
   day=any

Include

   options="-subdir=yes"

if you wish to traverse subdirectories of the db1 and db2 directories.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Peter Ford <PFord AT STENTOR DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04/10/2003 15:50
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Defining Schedules with Options



I need some advice on defining schedules for backing up specific files off
client machines, at a specific time.  I have read the Administrator's
Reference on defining client schedules but want to make sure that I
understand this correctly.

Every day, we backup either a full or differential backup from 3 SQL
databases, to specific directories.  These files are bound to specific
management classes, to make sure we retain the proper number of versions.
I want to define a schedule that will backup only these files, and bind
each to their specific Management Class.  We backup the remaining files on
the server using options specified in the dsm.opt, using another schedule.


def schedule standard once_a_day_schedule type=client
        desc="Daily backup of SQL backups"
        action=Incremental
        objects="exclude *\...\*
        include e:\sqlbackups\db1\*.bak FULLBACKUPS
        include e:\sqlbackups\db2\*.bak DIFFBACKUPS"
        startdate=04/10/2003 starttime=00:30
        duration=12 durunits=hours period=1 perunits=days
        day=any

If I define the schedule above, will I backup these files once a day and
bind them to the specified management classes?

Thanks in advance for your help.
Peter

    Peter Ford
    System Engineer


Stentor, Inc.
 5000 Marina Blvd,
 Brisbane, CA 94005-1811
 Main Phone: 650-228-5555
 Fax: 650 228-5566
 http://www.stentor.com
 pford AT stentor DOT com