• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 293
  • Last Modified:

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
0
prismabi
Asked:
prismabi
  • 2
1 Solution
 
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 SARICACommented:
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
 
Melih SARICACommented:
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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now