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:
> 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....|||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...
> I´m going nuts....sql