Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay1Jay
Yak Posting Veteran
50 Posts |
 Posted - 2004-10-21 : 15:39:24
|
| My company has purchased a product called TDPSQL from IBM. This product backs up databases/logs directly to ADSM/TSM on open systems rather than writing to local disk on sQL server and than backing up. I'm not sure if anyone is familiar with this product, but I am having a problem in my enviroment. My enviorment is such that I have ACTIVE-->Active Clustered SQL2000 server. With physical servername of Srv1 and Srv2. My SQLSERVER name for each node is SQL01 and its instance name is Inst1 and on my SRV2 server, SQL Server name is SQL02 with instance name of Inst2. When I try to open the GUI for TDPSQL, I am getting the following message:ACO5424E Could not connect to SQL server; SQL server returnedI checked all the settings and everything looks good...Please help.....Thanks,Jay |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-10-21 : 18:14:30
|
| yes, I am very familiar with this product.When you fire up the TDPSQL GUI frontend tool, it will fail because you are not pointing it to the dsm.opt file that contains the information needed to authenticate to the backend TSM server. by default, it will be using the dsm.opt file that is used to backup the C: drive of the node your are running on, instead of the dsm.opt file that has the details for the virtual host you want to backup/restore. chances are you do not have the software installed properly on your clustered environment. Have you registered your cluster's virtual hostnames as nodes in TSM? Do you have the TSM client installed on all nodes of your cluster? Do you have separate dsm.opt files for each node registered in TSM?Lets say I have a 2 node cluster (node-A and node-B are their hostnames), and on this cluster I have installed 3 instances of SQL Server. I will have to register atleast 6 or 7 node names in TSM to handle backups (depending if you have MSDTC running in its own group). This breaks down to the 2 physical nodes hostnames, the 3 virtual hostnames for the SQL Servers, and the cluster virtual hostname (for backing up the quorum disk). All of these need to be registered in TSM as nodes for things to work right.All of this info is in the installation guide for TSM and TDP. I think there is an appendix that has all the info you need. btw, what release of TSM are you using?If all else fails, call 1-800-IBM-HELP and log a support call.-ec |
 |
|
|
|
|
|
|
|
TDPSQL