Post reply

Problem with Modifing Backup Plan

  • January 26, 2009 at 12:01 am

    #383803

    Hi,

    When I am modifying my backup plan, I am getting the below error:

    "TITLE: Microsoft SQL Server Management Studio.Value cannot be null.Parameter name: component (System.Design)".

    I have installed SQL 2005 Service packs 2 & 3,But also having the same problem.Please help in this,

    Thanks In Advance,

    Thanks&Regards

    Shyam Surapaneni

  • January 26, 2009 at 4:44 am

    #932519

    Hi

    There are multiple reasons this can occur. One of them is your network packet size setting:

    In SQL Server 2005, when setting the network packet size option to 16,388 or above, it is possible that maintenance plans will fail to run. Users may also be unable to save new maintenance plans, receiving an error similar to "OLE DB error code 0x80004005 (Communication link failure)" with the SaveToSQLServer method. Editing and loading of existing maintenance plans will fail with the message: Value cannot be null. Parameter name: component (System.Design).

    - http://technet.microsoft.com/en-us/library/ms187866(SQL.90).aspx

    James Howard

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply