What version of SQL are you running? I'm having the same problem. I put
the sqlfull.cmd on the root of my C: drive. Let me know if you find out
anything useful.... I'm at the point of spending the day on the phone with
Tivoli....
I've tried logging the schedule service on as different users & changing cmd
file to logon as SA to execute the backup command. But neither has worked
when I let the scheduler start the backup.
I'm running SQL 7.0 SP3 on Win2k Advanced Server SP2.
--------------------------------------
Bruce Kamp
Network Analyst II
Memorial Healthcare System
P: (954)987-2020 x6008
F: (954)985-2274
E: [EMAIL PROTECTED]
----------------------------------------
-----Original Message-----
From: Zoltan Forray/AC/VCU [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 9:17 AM
To: [EMAIL PROTECTED]
Subject: TDP MS SQL client errors
I am seeing the following errors in my dsmerror.log after a scheduled CMD:
09/03/2001 19:26:19
Executing Operating System command or script:
D:\Program Files\TIVOLI\TSM\TDPSQL\sqlfull.cmd
09/03/2001 19:26:20 Finished command. Return code is:
1
09/03/2001 19:26:20 ANS1512E Scheduled event 'BACKUP.ACADNT3.SQL' failed.
Return code = 1.
09/03/2001 19:26:20 Sending results for scheduled event
'BACKUP.ACADNT3.SQL'.
09/03/2001 19:26:21 Results sent to server for scheduled event
'BACKUP.ACADNT3.SQL'.
How do I figure out what is happening ?
I can execute the sqlfull.cmd file manually, and it works just fine.
I don't see anything in the tdpsql backup logs or error files ????
Any suggestions ?
===========================
Zoltan Forray
Virginia Commonwealth University
University Computing Center
e-mail: [EMAIL PROTECTED]
voice: 804-828-4807