Posted by Trevor Best on 10/02/66 11:26
Thanks, I've read the links you provided but none have helped.
I can actually run the plan from an NT command prompt window and the
backup runs OK and the plan exits with code 0 (success).
It's just running from the SQLAgent or from Query analyser it fails
immediately without having done anything. It's as though it just can't
execute sqlmaint.exe. I can run other xps such as xp_msver without
trouble so I'm sure the paths are correct.
I checked HKLM\SOFTWARE\Microsoft\MSSQLServer\Setup (not where the
first link says it is) and the path is set correctly.
Navigation:
[Reply to this message]
|