Posted by Trevor Best on 06/13/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.

[Back to original message]