Заметки сисадмина » Can’t Modify/Delete Maintenance Plans in SQL 2005 after Rename

Заметки сисадмина о интересных вещах из мира IT, инструкции и рецензии. Настраиваем Компьютеры/Сервера/1С/SIP-телефонию в Москве

Can’t Modify/Delete Maintenance Plans in SQL 2005 after Rename

2012-11-11 · Posted in SQL

After renaming SQL Server 2005 server the maintenance plans couldn’t be deleted. When trying to delete or modify a plan user gets an error. Using the SSMS there is no way to delete the plan. I thought it might a similar issue to I had encountered with SQL Server 2000 Jobs; so I searched to see if Maintenance plans table was storing server name and couldn’t find anything. Tracy found Microsoft Connect Article, Link indicating this is a bug. But Tracy found a work around that will allow you to delete the old plans (please use with cautious as it is modifying system tables):

1)Manually delete Maintenance Plan from MSDB using script below.
2)Delete the SQL Server Jobs with the Management Studio.

Leave a Reply