SQL TDP Schedule Failed Error 402

hknd

Active Newcomer
Joined
Apr 8, 2010
Messages
6
Reaction score
0
Points
0
PREDATAR Control23

Hi,

TSM provides the following error when sql backup does not complete the schedule. I've reviewed similar topics in the forum but did not respond very healthy for me

TDP schedule works in a command file. It could not be something to do with it?

Error messages:

1.message

Schedule SQL-TDP in domain DAILYDOMAIN for node SQL-TDP failed (return code 402). (SESSION: 37945)

2.message

Ensure that a scheduler is running on each client and ensure that the scheduler's option file is pointing to the correct server.

Thanks.
 
PREDATAR Control23

What was in the TSM Server Activity log around the time of this failure? A return code of 402 from the TDP is a generic error and information needs to be gathered from other sources, such as the activity log, local error logs etc, Windows Event log etc in order to troubleshoot it.

If the command executes correctly from the command line but doesn't from the schedule, double check that the schedule has the correct path to the script, and that the user the scheduler is running as has appropriate permissions to perform the backup operation (a common issue with MS SQL backups).

HTH,

/David Mc
London, UK
 
Top