Unable to delete Maintanance Plans

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

grustni SSC Journeyman Points: 92 More actions · Answer 1

Since right-click -> delete...did not work, I ran these three simple steps, that I found on the Internet and it solved my problem.

Step 1:

Execute the below query to obtain the Maintenance plan name and Id

SELECT NAME, ID FROM MSDB..SYSMAINTPLAN_PLANS

Step 2:

Replace the Id obtained from Step 1 into the below query and delete the entry from log table

DELETE FROM SYSMAINTPLAN_LOG WHERE PLAN_ID=' '

Step 3:

Replace the Id obtained from Step 1 into the below query and delete the entry from subplans table as shown below,

DELETE FROM SYSMAINTPLAN_SUBPLANS WHERE PLAN_ID = ' '

Step 4:

Finally delete the maintenance plan using the below query where ID is obtained from Step1

DELETE FROM SYSMAINTPLAN_PLANS WHERE ID = ' '

NOTE: Run it in msdb system database!

george sibbald SSC Guru Points: 104210 More actions · Answer 2

thanks for posting solution back grustni.

moving msdb to a different server\renaming server has become a minefield since SQL2005. Let us know if you hit any other related problems.

---------------------------------------------------------------------