After I sent my last post I remembered this (from dsm.smp)


*======================================================================*
* The following include statements assign all meta objects to          *
* management class SqlDbMetaMgmtClass and all data objects to          *
* SqlDbDataMgmtClass                                                   *

*======================================================================*

*INCLUDE "\...\meta\...\*"     SqlDbMetaMgmtClass
*INCLUDE "\...\data\...\*"     SqlDbDataMgmtClass

*======================================================================*
* The following include statements assign all log meta objects to      *
* management class SqlLogMetaMgmtClass and all log data objects to     *
* SqlLogDataMgmtClass                                                  *

*======================================================================*

*INCLUDE "\...\meta\...\log*"  SqlLogMetaMgmtClass
*INCLUDE "\...\data\...\log*"  SqlLogDataMgmtClass

*======================================================================*
* The following exclude statements exclude all log backups for         *
* databases master and msdb                                            *
*======================================================================*

*EXCLUDE "\...\master\...\log*"
*EXCLUDE "\...\msdb\...\log*"                




Del, 
can you comment this. You said that we cannot exclude databases in this
release. I never used it, but I think this is what Luc is looking for;
to exclude log backup of master db.



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
Del Hoobler
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