saving maintenance plan failed in sql2008

  • I am getting the error message when I am creating maintenance plan and try to save it, I am using windows 2008 64 bit and Sql2008 earlier it was working properly but suddenly I start facing the issue. Please see the error message

    Saving maintenance plan failed.

    ------------------------------

    ADDITIONAL INFORMATION:

    The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Communication link failure). The SQL statement that was issued has failed.

    I register the msxml3/6.dll also but problem remain.

    Visharth

    visharthasthana@gmail.com

  • HI,

    Have you applied service pack on SQL Server 2008??

    Apply service pack on fresh installation & then try saving maintenance plan.

    Akshay G.

  • Stop using maintenance plans. go to ola.hallengren.com and use the FREE and fully documented goodness there! Awesome stuff.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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