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 |
|
rino19ny
Starting Member
2 Posts |
 Posted - 2011-07-17 : 09:09:41
|
win2k3 server sp2sqlserver 2k sp3we used to have this maintenance plan to backup our databases and now it is not working. i made sure that the destination disk have enough space but i still get the error:Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. the maintenance plan (when viewed in the properties) have this inside:[code]EXECUTE master.dbo.xp_sqlmaint N'-PlanID 524C3A14-C8A9-46C7-A231-C53D305825E5 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "F:\dbbackup" -CrBkSubDir -BkExt "BAK"'[\code]the plan was created from Maintenance -> Database Maintenance Plans using gui so i doubt a typo is causing the error.googling for the error turns up mostly saying to check the space which i've done. the database is 200GB and i have allocated a 1TB drive for the destination.how else to fix or know the cause of the problem? |
|
|
rino19ny
Starting Member
2 Posts |
Posted - 2011-07-18 : 07:58:44
|
| WOOOHOOOO!!!!!i fixed it! F@#$G maintenance plan!i use t-sql commands and now all is working fine.woohooo!!! |
 |
|
|
|
|
|
how to fix [SQLSTATE 42000] (Error 22029)