Transaction log backup job for db maintenance ERROR in SQL Server

Dear experts,
I try to run a job, but i got an instant error:
"SQLMaint.exe failed. [SQLSTATE 42000] [error 22029]. the step failed."
Any tip will be apprieciated.
Thanks
prismabiAsked:
Who is Participating?
 
Melih SARICAConnect With a Mentor OwnerCommented:
try this link

From Msdn
Knowledge Base  
PRB: Maintenance Job Fails on Named Instances of SQL Server 2000 with Error 22029

http://support.microsoft.com/default.aspx?scid=kb;en-us;326485

Melih SARICA
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Right-click on the job, choose "View Job History..." option and check "Show step details". See at details (step_id > 0) if any information can help you.
You can check SQL Server logs also.

I hope that helps you. Good luck.
0
 
Melih SARICAOwnerCommented:
or this Link

BUG: Expired Transaction Log Backups May Not Be Deleted by Maintenance Plan
http://support.microsoft.com/kb/303292/EN-US/

Melih SARICA

0
 
prismabiAuthor Commented:
Dear Melih,
Thanks for your great help and sorry again for the delay.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.