Posted by Trevor Best on 11/09/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.

• Next in forum: Import Spreadsheet error
• Prev in forum: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
• Thread view: Re: sqlmaint.exe failed

[Reply to this message]