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 |
|
mufasa
Yak Posting Veteran
62 Posts |
 Posted - 2004-11-02 : 11:24:06
|
Everytime I try to run the optimization maintanance, I get this error.It runs for about 30 minutes then returns this error.Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.I've tried to find the description of this error, but can not.Please helpThanksMufasa  |
|
|
MuadDBA
628 Posts |
Posted - 2004-11-02 : 12:58:21
|
| This is a prime example of why not to use maintenance plans.However, cehck the maintenance plan, it should create either a history table or a history log file, or both, and you should be able to check those for the actual reason the job is failing.Common reason: You ran out of disk space, or you ran out of transaction log. |
 |
|
|
|
|
|
[SQLSTATE 42000] (Error 22029)