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.