[急]测试日志传送错误：22029

[zonelive]

操作系统：WINDONWS 2003SERVER
数据库：SQLSERVER2000+sp4

出现的问题：
在次服务器的一个作业时而出现“sqlmaint.exe failed.[SQLSTATE 42000][Error 22029].The step failed”

1、作业记录中成功和失败的都存在；
2、每次失败手动执行作业都会成功；

参考“PRB:SQL Server 2000 命名实例上的维护作业失败，返回错误 22029”
http://support.microsoft.com/kb/326485/zh-cn?spid=2852&sid=1223

与里面说的路径含“-S”引起的也不存在

数据库路径：c:\Program Files\Microsoft SQL Server

日志传送的数据存储路径：C:\Shippedlog

[-狙击手-]

与里面说的路径含“-S”引起的也不存在
--

这个有可能的呀，当服务器名检测了，嘿嘿

[rouqu]

From Q288577
If any task in a Database Maintenance plan fails or encounters an error message, the maintenance plan job itself may show as failed. The Job History Details shows the following error message:
sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.
However, this does not necessarily indicate that the Maintenance Plan as a whole has failed. The Maintenance Plan job shows a status of failed in order to raise a flag to the user that a task in the maintenance plan requires attention.

This kind of behavior is normal because errors may be encountered that need user intervention to work through. Any time a maintenance plan job fails, you must check the plan history to see what the failure is and then take the appropriate action to resolve the problem.
--------------
楼主去检查一下该作业的历史记录 查看具体那一步骤发生了错误

这篇KB里还提到 可以使用sqlagent.exe -c -v来获得更详细的作业记录 即services.msc中停止agent再命令行方式启动

重run作业 查看错误

[zonelive]

原因找到了，是我开始想到的情况

[rouqu]

开始想到的什么情况哦