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
Still no responses. Have any of you experienced the same problem?
Thank you,
JackS
|||I will follow up with our team and get back to you on this. You can reach me at gdwarak at microsoft dot com(not to get spammers attention) in case i do not get back in couple of days.|||That is right this is a bug and is planned to get addressed in next service pack.
Gops Dwarak, Microsoft.
|||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
|||install SP2 problem solved
No comments:
Post a Comment