I am unable to delete my SQL Server 2005 legacy database mainenance plans. Here are the steps taken in SQL Server Management Studio:
- Expand Management | Legacy | Database Maintenace Plans
- Right click one of the maintenance plans
- Select "Delete"
A Delete Object window is displayed. I click the OK button, and the Management Studio no longer displays the maintenance plan. But after refreshing the view, the maintenance plan reappears. It wasn't really deleted.
I also tried another way of deleting it. In the Delete Object window, I selected "Script Action to new Query window", then ran the query. It did not delete the maint plan.
Any suggestions
Thanks,
JackS
Deleting legacy maintenance plans - 2005
tamlin2
Hi Gops!
I (we) 've got the same problem with a lot of customers running SAP on MSSQL.
Therefore there's a lot of trouble about this issue.
Do you or anybody elsing reading this, have a workaround killing these legacy plans.
I mean: it just looks like an annoying thing, but these plans do run. And for example if you have got planned lot's of backups with maint plans it is "more than annoying".
Thanks in advance.
Carsten Loeffler
Scott Vande Krol
Still no responses. Have any of you experienced the same problem
Thank you,
JackS
Badekapp
That is right this is a bug and is planned to get addressed in next service pack.
Gops Dwarak, Microsoft.
anil_m_s
RandyTM