Re: scheduled SQL log backup question

2004-12-02 Thread Del Hoobler
Luc, I have this in my DSM.OPT file: EXCLUDE "\...\master\...\log*" Here is the output when I try to back up the log of master: - C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc backup master log IBM Tivoli Storage Manager for Databases: Data Protection for

Re: scheduled SQL log backup question

2004-12-02 Thread Luc Beaudoin
Hi All I want to EXCLUDE the LOG BACKUP of the MASTER DB I went in the dsm.opt file in the \TDPsql folder, and I removed the * in front of the : EXCLUDE "\...\master\...\log*" EXCLUDE "\...\msdb\...\log*" But it still try to take it When there is a exclude , if I go in the SQL GUI and try

Re: scheduled SQL log backup question

2004-11-30 Thread Del Hoobler
ski - 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, Novem

Re: scheduled SQL log backup question

2004-11-30 Thread Joe Crnjanski
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

Re: scheduled SQL log backup question

2004-11-30 Thread Steve Schaub
table. 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 k

Re: scheduled SQL log backup question

2004-11-30 Thread Del Hoobler
"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 t

Re: scheduled SQL log backup question

2004-11-30 Thread Luc Beaudoin
uot;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 "tdps

Re: scheduled SQL log backup question

2004-11-30 Thread Joe Crnjanski
etwork 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 bac

scheduled SQL log backup question

2004-11-30 Thread Luc Beaudoin
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