Re: TDP backup command batch file

Moses,
some spaces appear in your command that may be causing you the problem. I
use the following and there are no spaces between %sql_dir% and the \ that
follows.

%sql_dir%\tdpsqlc backup Quillix full /tsmoptfile=%sql_dir%\dsm.opt
/logfile=C:\TSMJOBS\Quillix_full.log >> C:\TSMJOBS\Quillix_sched.log
Maybe you would like to give it a try.
Yiannakis

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Moses Show
Sent: Monday, June 21, 2004 12:23 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: TDP backup command batch file


Am using TDP for SQL 5.2.1 to back up SQL databases on a client node.
However when the SQL databases come to be backed up they keep failing with
the following TSM error codes: ANS1038S and ANS1820E. These point to the
problems with the sqlfull.cmd file. The format which I am using is

"%sql_dir% \tdpsqlc backup * full  /tsmoptfile=%sql_dir% \svrname.opt
/logfile=%sql_dir  \sqlfull.log >> %sql_dir% \sched.log"

with \svrname.opt=dsm.opt from the tdpsql installation directory.

On some client nodes the sqlfull.cmd does not exist, although the same
details are contained in sqlfull.smp
On one of the client nodes the sqlfull.cmd does exist but the result
remains the same.
Can anyone point out what or indeed where I am going wrong as I need to
try and get this backup working.


Thanking you all on this forum for the invauable help you have given me in
the past.
============================================================================
==
This communication, together with any attachments hereto or links contained
herein, is for the sole use of the intended recipient(s) and may contain
information that is confidential or legally protected. If you are not the
intended recipient, you are hereby notified that any review, disclosure,
copying, dissemination, distribution or use of this communication is
STRICTLY PROHIBITED.  If you have received this communication in error,
please notify the sender immediately by return e-mail message and delete the
original and all copies of the communication, along with any attachments
hereto or links herein, from your system.

============================================================================
==
The St. Paul Travelers e-mail system made this annotation on 06/21/2004,
05:19:17 AM.