sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)

• rino19ny

  SSC Enthusiast

  Points: 196

  More actions

  July 18, 2011 at 1:40 am

  #244459

  win2k3 server sp2

  sqlserver 2k sp3

  we 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:

  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

  SSC Enthusiast

  Points: 196

  More actions

  July 18, 2011 at 5:56 am

  #1354173

  woohooo!!! i fixed the problem. D#@d maintenance plan!

  i use t-sql commands for the backup and restore and now they're all working!!!

  wooohoooo!!!!