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
