Del/Luc,

I just finished setting up our TDP environment and hit this as well -
the easiest way out is to code a client option set for your TDP-SQL
nodes that excludes the log backups from master.  Mine looks like this:

compression           yes
inclexcl              "include '\...\*' STD_SQLDB"
inclexcl              "exclude '\...\master\...\log*'"

Your activity log results will then show excluded backups

Steve Schaub
Computer Storage Systems Engineer II
Haworth, Inc
616-393-1457 (desk)
616-886-8821 (cell)
Steve.Schaub AT Haworth DOT com 
"Trials are inevitable.  We can curse them and grow bitter, or harvest
them and grow stronger"
       

-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM] 
Sent: Tuesday, November 30, 2004 1:55 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: scheduled SQL log backup question


Luc,

This is a known requirement that has been submitted and being
prioritized for a future release, i.e. allowing you to "exclude" certain
databases from a command.

Thanks,

Del

----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 11/30/2004
01:47:30 PM:

> Thanks Joe .....
>
> I thought of that one but I was hopping for a nice exetp option ... 
> cool .. I will do that way...
>
> thanks again
>
> Luc
>
>
>
>
>
> Joe Crnjanski <JCrnjanski AT INFINITYNETWORK DOT COM>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 2004-11-30 
> 01:35 PM Please respond to "ADSM: Dist Stor Manager"
>
>
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         cc:
>         Subject:        Re: scheduled SQL log backup question
>
>
> I think you cannot take log backup of master db; only full; that 
> doesn't matter, it is small database (but very important)
>
> In your script put "tdpsqlc backup db1,db2,db3,db4 log ....."
>
> Db1,db2... are database names (don't include master)
>
> Joe Crnjanski - Partner
> Infinity Network Solutions Inc.
> Phone: 416-235-0931 x26
> Fax:     416-235-0265
> Web: www.infinitynetwork.com
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of Luc Beaudoin
> Sent: Tuesday, November 30, 2004 11:56 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: scheduled SQL log backup question
>
> Hi all
>
> I'm doing SQL LOG backup every 6 hours and a full backup every day ...
>
> I got a failed status everytime cause I can not take theLOG backup of 
> the master DB ...
>
> This is the command that I launch ...
>
> %sql_dir%\tdpsqlc backup * log /tsmoptfile=%sql_dir%\dsm.opt 
> /logfile=%sql_dir%\sqllog.log >> %sql_dir%\sqlschedlog.log
>
> Is there a option that I can put .. like   backup ALL LOG except
MASTER
>
> thanks
>
> Luc Beaudoin
> Network Administrator/ SAN/TSM
> Hopital General Juif S.M.B.D.
> Tel: (514) 340-8222 ext:8254