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) [EMAIL PROTECTED] "Trials are inevitable. We can curse them and grow bitter, or harvest them and grow stronger" -----Original Message----- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 30, 2004 1:55 PM To: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-11-30 > 01:35 PM Please respond to "ADSM: Dist Stor Manager" > > > To: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED] On Behalf > Of Luc Beaudoin > Sent: Tuesday, November 30, 2004 11:56 AM > To: [EMAIL PROTECTED] > 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