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