SQL Server Performance Forum – Threads Archive
Maintenance plan failed
I have a Maintenance plan in sql 7.0 which take backup.I found strange thing there ,In job it show error But it is not showing an error in maintenance plan history there it show as success. Here is the Error from Jobs history.——————————
sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed.
—————————— Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
Check this
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4200
quote:Originally posted by rajeev_id
I have a Maintenance plan in sql 7.0 which take backup.I found strange thing there ,In job it show error But it is not showing an error in maintenance plan history there it show as success.
Here is the Error from Jobs history.
——————————
sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed.
—————————— Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
——————————
sqlmaint.exe failed. [SQLSTATE 42000][Error 22029]. The step failed.
—————————— Rajeev Kumar Srivastava
–ALWAYS BE POSITIVE!–
Dinesh I’ve corrected the referred link as it was opening in quote format. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thankx satya
quote:Originally posted by satya
Dinesh
I’ve corrected the referred link as it was opening in quote format.
Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>