Yes.  

Create a directory on a drive that is going to follow the instance of
SQL Server you want to backup.  Put your .opt file and .cmd files in
that directory, and optimally also have your logs written to that
directory.  Then changes are centralized and failovers can be tracked as
they affect TSM as well as the SQL Server.

See Ya'
Howard Coles Jr.
Sr. Systems Engineer
Nashville, TN

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Gill, Geoffrey L.
> Sent: Wednesday, March 19, 2008 6:36 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] ttdpsql in a cluster environment
> 
> Perhaps others have already dealt with this.
> 
> 
> 
> Is there a way to create a single .cmd file that can be used for one
> schedule with multiple sqlservers in a cluster environment so it will
> run properly no matter what instance is on any one node or may have
> failed to a node it normally does not live on and not report a
failure?
> Or do I have to make separate schedules for every node each with its
> own
> .cmd file and make sure the .cmd files are on all cluster nodes?
> 
> 
> 
> 
> 
> Geoff Gill
> TSM Administrator
> PeopleSoft Sr. Systems Administrator
> SAIC M/S-G1b
> (858)826-4062
> Email: geoffrey.l.gill AT saic DOT com