how to remove maintanance backup plan.

• zalie05

  Grasshopper

  Points: 13

  More actions

  April 10, 2009 at 3:39 am

  #202914

  hi everyone.i have a question about maintanance plan.

  i have create one backup plan in SQL 2005 like monday.bak plan and now on it can't runnig like usual.my question is how to remove the maintanance plan backup

  can anyone help me step by step how to remove it.coz when i try to remove using wizard it showing error to remove it. pls help me. thank

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  April 10, 2009 at 5:34 am

  #975665

  Hi

  Can you tell what is the error.

  Tanx 😀

• Scott Ohar

  Hall of Fame

  Points: 3607

  More actions

  April 10, 2009 at 11:19 am

  #975909

  If you're not able to do it via SSMS you could always just go through the msdb

  Select *

  FROM

  sysmaintplan_subplans AS subplans

  INNER JOIN

  sysjobs_view AS syjobs

  ON

  subplans.job_id = syjobs.job_id

  WHERE (syjobs.name = 'job_name')

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  April 10, 2009 at 3:42 pm

  #975980

  use msdb

  go

  select * from sysjobs --collect all the job information

  go

  begin tran

  '

  delete from dbo.sysmaintplan_log where subplan_id =

  '<>'

  delete from dbo.sysmaintplan_subplans where job_id =

  '<>'

  delete from dbo.sysjobschedules where job_id =

  '<>'

  delete from dbo.sysjobs where job_id = '<>'

  commit tran

  --The jobs were deleted

  If you want to delete maintenance plan manually using SQL Query

  --Delete the Maintenance Plan

  select * from dbo.sysdtspackages90 --find the maint plan and replace in the next query

  delete from dbo.sysdtspackages90 where name = '<>'