Why cannot the Maintenance Plan be deleted

博雄 胡 20 Reputation points
2024-01-31T09:09:18.4833333+00:00

报错

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,298 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CosmogHong-MSFT 20,521 Reputation points Microsoft Vendor
    2024-02-01T03:01:45.9233333+00:00

    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.