Bo,
-2147024891 is AccessDenied.
This is a security/permissions/access rights error code.
Does the SQL Server user id used by TDP for SQL have the
SQL Server SysAdmin Fixed Server Role?
Does the Windows NT user id that actually runs the
scheduler for TDP for SQL have admin authority?
The return code that the scheduler sees from a COMMAND
type schedule is a return code generated from the
command file execution and not the commands that it runs.
To determine success or failure for certain,
examine the sqldsm.log.
Thanks,
Del
----------------------------------------------------
Del Hoobler
IBM Corporation
[EMAIL PROTECTED]
"It's a beautiful day. Don't let it get away." -- Bono
Bo Nielsen
<Bo_Nielsen@FD To: [EMAIL PROTECTED]
B.DK> cc:
Sent by: Subject: SQL backup failed.
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
IST.EDU>
06/27/2001
06:44 AM
Please respond
to "ADSM: Dist
Stor Manager"
Help.
I'm running a backup on a SQL server 7.0.
Sometime everything is OK, but mostly fail some
of the DB's with the follow errors from the SQL log:
BackupVirtualDeviceSet::Initialize: Open failure on backup device
'TDPSQL-sqladsm-2001021544-3180'. Operating system error -2147024891(error
not found).
>From the TSM log:
06/27/2001 02:15:52,Backed up - FMRK, type: DB, size: 231583513, actual
bytes: 0, secs: 0,00, Kb/Sec: 0,00, SQL server: FDB033, TSM server: dsm,
SQL
status: DB-LIB message: Backup or restore operation terminating abnormally.
, TSM status: TSM operation cancelled.
The configuration is:
TSM server OS/390 version 4.1.30
SQL server 7.0 on NT 4 sp5
TDP SQL agent 1.1.2
Why is the scheduled event ' ' completed successfully,
when the backup is terminated for some DB's??????
Regards,
Bo Nielsen
FDB data Phone: +45 4386 4671
Roskildevej 65 Fax: +45 4386 4990
DK-2620 Albertslund E-mail: [EMAIL PROTECTED]
Denmark
