ADSM-L

TDP for MSSQL

2001-12-03 18:19:14
Subject: TDP for MSSQL
From: Gerald Wichmann <gwichmann AT SANSIA DOT COM>
Date: Mon, 3 Dec 2001 15:17:13 -0800
TDP for MSSQL v2.2.0
TSM Server AIX 4.3.3 with TSM 3.7.5

When we run the cmd file manually form the command prompt, it backs up
fine.. But we can't seem to make scheduled backups work and I'm getting
very little info as to why. Does the following error mean anything to
anyone? A help on ANS1512E yields no useful info and I have no idea what
a return code of 1 is. Also nothing gets logged in the other log files
like sqldiff.log, sqlfull.log, sqlsched.log, etc. So I'm having a real
hard time figuring out why it keeps failing.

dsmsched.log

12/03/2001 03:57:34 Node Name: GRAND_DB
12/03/2001 03:57:34 Session established with server UTSLC01: AIX-RS/6000
12/03/2001 03:57:34   Server Version 3, Release 7, Level 5.0
12/03/2001 03:57:34   Server date/time: 12/03/2001 04:03:35  Last
access: 12/02/2001 16:27:35

12/03/2001 03:57:34
Executing Operating System command or script:
   c:\Program Files\Tivoli\TSM\TDPSql\sqldiff.cmd
12/03/2001 03:57:34 Finished command.  Return code is:
   1
12/03/2001 03:57:34 ANS1512E Scheduled event 'LIFELINK-SQLDIFF' failed.
Return code = 1.
12/03/2001 03:57:34 Sending results for scheduled event
'LIFELINK-SQLDIFF'.
12/03/2001 03:57:35 Results sent to server for scheduled event
'LIFELINK-SQLDIFF'.

dsmerror.log

12/03/2001 03:57:34 ANS1512E Scheduled event 'LIFELINK-SQLDIFF' failed.
Return code = 1.


Gerald Wichmann
System Engineer
StorageLink
408-844-8893 (v)
408-844-9801 (f)
<Prev in Thread] Current Thread [Next in Thread>