ADSM-L

scheduled SQL log backup question

2004-11-30 11:55:55
Subject: scheduled SQL log backup question
From: Luc Beaudoin <lbeaudoi AT IS.JGH.MCGILL DOT CA>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 30 Nov 2004 11:55:36 -0500
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

<Prev in Thread] Current Thread [Next in Thread>