Need help TDP for SQL fails on a cluster node with Failed 1

[pavchinn]

My daily schedule backup is failing with Failed 1

This is all there in the log file. even after changing the permission for services it failed

11/09/2010 04:00:48 Command will be executed in 10 minutes.
11/09/2010 04:10:48
Executing scheduled command now.
11/09/2010 04:10:48 Node Name: SCFLOKYDCMSQL81_SQL
11/09/2010 04:10:48 Session established with server FLOTSM2: AIX-RS/6000
11/09/2010 04:10:48 Server Version 5, Release 5, Level 1.1
11/09/2010 04:10:48 Server date/time: 11/09/2010 04:10:48 Last access: 11/09/2010 04:00:48
11/09/2010 04:10:48
Executing Operating System command or script:
c:\progra\~1\tivoli\tsm\tdpsql\sqlfull.cmd e
11/09/2010 04:10:48 Finished command. Return code is: 1
11/09/2010 04:10:48 ANS1909E The scheduled command failed.
11/09/2010 04:10:48 ANS1512E Scheduled event 'TESTTDP' failed. Return code = 1.
11/09/2010 04:10:48 Sending results for scheduled event 'TESTTDP'.
11/09/2010 04:10:48 Results sent to server for scheduled event 'TESTTDP'.

I can start the TDP for cluster drive manually and take backup but only scheduled backup fails.

Server win 2003 - SQL 2005 - BACLIEnt - 5.5.2.12 - TDP - 5.5.3.2

 

[moon-buddy]

First thing to check: does the script call the right location for your SQL database?

On cluster setups, shared environment actions (backups, services, etc) are normally called from the cluster shared resources unless careful attention have been given in setting this up properly to be called from the active node.