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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-08 : 10:12:55
|
| Toan writes "I'm getting this error when I run a maintainence job:The job failed. The Job was invoked by User Domain\user. The last step to run was step 1 (Step 1).Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.Microsoft has an article for a workaround but it doesn't seem to help.http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246815Any suggestions is appreciated. Thanks." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-08 : 10:23:41
|
| Is there a reason you are trying to run your backups through a maintenance plan? From what I've seen, the maintenenace plan problems tend to be difficult to troubleshoot. Why not just use a regular T-SQL "BACKUP DATABASE" command, put it in a job and forget about sqlmaint? |
 |
|
|
|
|
|
backup