Maintanence plan challenge!

Heres a challenge...
Sudddenly our backup maintanence plan stoped working. In the job history the
following error is displayed:
The job failed. The job invoked by the user sa. The last step to run was
step 1 (Step 1).
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
The maintanence plan error log is empty.
The job does not backup transaction logs and i've deseleccted integrity
check. I've created a new database and recrated the maintanene plan on this
database with the same result. I also created a maintanence plan with only an
integrity check. Still the same result...
I′m going nuts....
Hi ,
Can you mail the syntax you are using for sqlmaint.exe along with any
switches that have been used.
Thanks & Regards
Vishal
"Stefan Andersson" wrote:

> Heres a challenge...
> Sudddenly our backup maintanence plan stoped working. In the job history the
> following error is displayed:
> The job failed. The job invoked by the user sa. The last step to run was
> step 1 (Step 1).
> Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error 22029). The step failed.
> The maintanence plan error log is empty.
> The job does not backup transaction logs and i've deseleccted integrity
> check. I've created a new database and recrated the maintanene plan on this
> database with the same result. I also created a maintanence plan with only an
> integrity check. Still the same result...
> I′m going nuts....
|||The maintanence plan are scheduled in Enterprise Manager so i dont run it
with any switches. It does not matter which type of maintanece plan i create
(backup, integrity check, etc).
"Vishal Gandhi" wrote:
[vbcol=seagreen]
> Hi ,
> Can you mail the syntax you are using for sqlmaint.exe along with any
> switches that have been used.
> Thanks & Regards
> Vishal
> "Stefan Andersson" wrote:
|||Specify a report file for the plan and check for error messages from SQL Server in the report file.
If you are lucky, you find SQL Server errors there.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Stefan Andersson" <StefanAndersson@.discussions.microsoft.com> wrote in message
news:A79A5153-3A52-4456-AE97-28130C174A6B@.microsoft.com...
> Heres a challenge...
> Sudddenly our backup maintanence plan stoped working. In the job history the
> following error is displayed:
> The job failed. The job invoked by the user sa. The last step to run was
> step 1 (Step 1).
> Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error 22029). The step failed.
> The maintanence plan error log is empty.
> The job does not backup transaction logs and i've deseleccted integrity
> check. I've created a new database and recrated the maintanene plan on this
> database with the same result. I also created a maintanence plan with only an
> integrity check. Still the same result...
> Im going nuts....