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
