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:[EMAIL PROTECTED] On Behalf Of Del Hoobler 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
