While I've been fighting this, I downloaded the 2.2.0.1 version of SQL. I'll update the client tomorrow. I'll get the newer client and do the same with it. Thanks for the files, I'll look them over and see how they are different from what I've been trying to do.
-----Original Message----- From: Edgardo Moso [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 4:25 PM To: [EMAIL PROTECTED] Subject: Re: Installing TDP for SQL 2.2 David, I have the same environment as you are. The TSMclient version 4.1.2.20 has many problems. What I did was, I upgraded mine to 4.1.3.11 It's now working fine. Also install the latest patch for TDP ver 2.2.0.0 , TDPver 2.2.0.1. Here's my sample dsm.opt file. Be sure to specify the correct TCPCLIENTADDRESS (client ip address) and TCPCLIENTPORT(1502 - be sure this is not used by other network) (See attached file: dsm.opt) This is the command that you need to define in your service schedule ( under object). You can try running in the command line. (See attached file: sqlfull.cmd) You need this also. Please take note: you may either run using integrated ( NT authentication) or sqluserid ( sql defined id). Either of this need to have a SA privilege in the SQL and NT system admin. (See attached file: tdpsql.cfg) Ed Moso From: "Adams, Matt (US - Hermitage)" <[EMAIL PROTECTED]> on 04/22/2002 03:20 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: Installing TDP for SQL 2.2 David, What do the parameters of your schedule look like on the TSM server?? Matt Adams Tivoli Storage Manager Team Hermitage Site Tech Deloitte & Touche USA LLP 615.882.6861 -----Original Message----- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 12:58 PM To: [EMAIL PROTECTED] Subject: Installing TDP for SQL 2.2 We are trying to install the TDP for SQL version 2.2 on to a WinNT4 machine running MS-SQL. So far we have the client (version 4.2.1.20) installed to catch all the non SQL files. It's set up to be called by the TSM server to run and it's doing fine. All the non SQL backups are fine. We have the SQL folders set to be excluded. We are now trying to install the SQL part now and it does not want to play nice. We loaded version 2.2.0.0 and we have gotten it working to point where we can do a SQL backup from the command line and from within the GUI. We can't get it run when it's called from the TSM server. The programs are all installed to the default locations and I ran the dsmcutil install command from the baclient folder to create a new scheduler service for the SQL part. I referred it to the dsm file in the tdpsql folder just like the docs said. I've got a schedule on the TSM server set to kick off at a certain time but nothing happens. I've looked at the assorted log files nothing shows up. If I run "tdpsqlc backup * full" it runs just fine. Am I missing something here? Do I need to call the sqlfull.cmd from one of the dsm.opt files? David Tyree Microcomputer Specialist South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. - This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. - If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.