Re: SQL backup failed.
2001-06-27 09:46:18
Bo,
-2147024891 is AccessDenied.
This is a security/permissions/access rights error code.
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
Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com
"It's a beautiful day. Don't let it get away." -- Bono
Bo Nielsen
<Bo_Nielsen@FD To: ADSM-L AT VM.MARIST DOT EDU
B.DK> cc:
Sent by: Subject: SQL backup failed.
"ADSM: Dist
Stor Manager"
<ADSM-L AT VM DOT MAR
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).
|
|
|