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.
