Why cannot the Maintenance Plan be deleted

Question

Version：2008r2 Language：Chinese Error Text：LoadFromSQLServer方法遇到了OLE DB错误代码0x80004005 (通讯链接失败)。发出的SQL语句已失败。 I tried searching, but couldn't find any content that was exactly the same as my situation. If you need me to provide additional information to improve the problem description, please leave a message. Thank you for your help.

Answer 1

This problem occurs when the configure network packet size (in bytes) is greater than or equal to 16388. However, if it is less than 16388 (such as the default 4096), this problem will not arise.

Upgrading to SQL Server 2008 R2 SP3 or a higher version of SSMS does not solve the problem.

Answer 2

Hi @博雄 胡

Version：2008r2

It seems like a by design issue. SQL Server 2012 introduced a new designer for maintenance plans so if you try and edit an earlier version of a maintenance plan with SSMS 2012 it will be saved in the new format, then the lesser versions of SSMS will not be able to open it.

Reference [MSDN article], point 5.5:

5.5 New Maintenance Plan Layout Not Compatible with Earlier SQL Server Tools Issue:
When SQL Server 2012 management tools are used to modify an existing maintenance plan created in a previous version of SQL Server management tools (SQL Server 2008 R2, SQL Server 2008, or SQL Server 2005), the maintenance plan is saved in a new format. Earlier versions of SQL Server management tools do not support this new format.Workaround: None

Referring from this thread: SQL Server 2012 Maintenance Plan can't modify.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.