TDP for SQL in a cluster

[TitusBandugula05011988]

Hello All,

I read how to configure TDP for SQL in a cluster and understand it.
I have two nodes, node1 & node2 running SQL in a Windows cluster called cluster001
TDP for SQL installed and defined nodes for SQL called node1_sql & node2_sql and created the required service in windows cluster on both nodes.
I def nodes on TSM servers for node1,node2,node1_sql,node2_sql,cluster001 and grant proxy authority.


When I define a schedule, should I associate the SQL nodes (eg. node1_sql,node2_sql) to the schedule or cluster001 ?

 

[moon-buddy]

If cluster001 has the TDP SQL nodes definitions, you can call the schedule from it. If not, call it from the SQL nodes.

For truly running a cluster setup, call the schedule from the TDP cluster name. I would do cluster001_sql for this and have the SQL nodes be called off from cluster001_sql.

 

[TitusBandugula05011988]

So, the "TDPSQL\dsm.opt" file should reflect the node names ('node1_sql and node2_sql') or cluster name (cluster001_sql) on both the SQL nodes?

 

[moon-buddy]

The dsm.opt file for cluster001_sql should have the configurations of the nodes so it can backup the SQL instances of either node. Access rights must be in place for cluster001_sql for either node.

https://www.ibm.com/support/knowled...itsm.db.sql.doc/c_dpfcm_plan_sqlwsfc_sql.html