sqlmaint.exe failed.

• paksyeet

  SSCommitted

  Points: 1596

  More actions

  August 12, 2008 at 4:21 am

  #123823

  Hi

  i know this error is not really new..

  EXECUTE master.dbo.xp_sqlmaint N'-PlanID 31F3F62F-CC7B-4B2F-AA82-D46E76811168 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "D:\APO - Database Backup\ProductionDatabases" -DelBkUps 1MONTHS -BkExt "BAK"'

  -- error from query analizer

  Server: Msg 22029, Level 16, State 1, Line 0

  sqlmaint.exe failed.

  --error from view job history

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

  --error from report

  no plan name for may maintenance plan

  --error from application log

  SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0x58CC559F756F7F4EB408D3447F93C50A) - Status: Failed - Invoked on: 2008-08-12 17:46:15 - Message: The job failed. The Job was invoked by User DOMAIN\username. The last step to run was step 1 (Step 1).

  but searching the net.. i still find no answer in my issue.

  Problem starts when our storage drive got full..

  i have this maintenance plan that was working smoothly in he last few weeks..

  but today, may maintenance plan keeps failing..

  ive recreate the maintenance plan.. but still same problem..

  one thing i notice is that when i execute

  select * from msdb.dbo.sysdbmaintplan_history - column 'plan_name' doesnt show the plan that i created..

  btw, i've already freed up tolerable disk space.

  SQL VERSION: Microsoft SQL Server 2000 - 8.00.194

• paksyeet

  SSCommitted

  Points: 1596

  More actions

  August 14, 2008 at 9:02 pm

  #858523

  help...