Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-03-01 : 01:42:04
|
| Hi,I have created a maintainance plan to backup all my user databases ,but it fails with following error :Executed as user: WEB1\Administrator. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.Any ideas?Thnks in Advance.Regards, Harshal.Expect the UnExpected |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-03-01 : 08:19:21
|
| You need to look at the maintenance plan history as you will not get anything useful from the job history. If you right click on the maintenace plan and choose history, you can filter just errors and double click on the error to see a more detailed error. You can also check the maintenance paln report if you choose to produce one when you set up the plan.HTHJasper Smith |
 |
|
|
|
|
|
maintainance plan failure