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