Post reply

Getting Error to create Maintenance Plan

  • March 27, 2009 at 3:42 am

    #129440

    Hi,

    I am getting error when I set auto backup for database through Maintenanace plan,I receive the following error.

    TITLE: Maintenance Plan Wizard Progress

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

    Create maintenance plan failed.

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

    ADDITIONAL INFORMATION:

    Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'. (Microsoft.SqlServer.MaintenancePlanTasks)

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

    BUTTONS:

    OK

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

    Please help me to resolve the above problem.

  • March 27, 2009 at 4:23 am

    #967276

    Is your agent running?

  • March 27, 2009 at 4:30 am

    #967278

    Yes sql server agent is running.

  • March 27, 2009 at 4:52 am

    #967289

    Are you setting up this job on your local server?

    Check this out, similar problem discussed here:

    http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/12181324-bc51-41a5-a8a5-608bfe2725e9/

  • March 27, 2009 at 5:01 am

    #967297

    yes i am setting up this job on local server .

  • March 27, 2009 at 5:19 am

    #967309

    Have you checked the link I provided? Similar problem discussed there.

  • March 27, 2009 at 6:06 am

    #967346

    Check wehter u have installed SSIS(Integration Services) and it is running If not try install it.

    Let me know wether it is 64bit or 32 bit

    Santhu

  • April 15, 2009 at 4:26 pm

    #978494

    getting the same problem from activity manager.

    running 64 bit, sp 2 installed, msdtc is running already...

    any thoughts?

  • April 15, 2009 at 4:51 pm

    #978507

    loren.saunders (4/15/2009)

    getting the same problem from activity manager.

    running 64 bit, sp 2 installed, msdtc is running already...

    any thoughts?

    and have you checked the questions we asked? Is your agent running and also did you check out the link?

    Can you give me more insight into your problem I mean error wise?

  • April 15, 2009 at 5:44 pm

    #978530

    I actually found out it was my client machine I was running Management Studio from.

    I had read all the different posts... apparently I need to upgrade the sql server installation on my own machine.

    The work around I used was to remotely log on to the sql server itself and use the job activity monitor from there.

    Now I'm running into a different problem... even though I am logged in as 'sa' when I try to delete old maintenance plans it says that my login failed as 'sa'... very strange.

    We just recently changed our sa password.

    and to answer your questions: yes, agent and msdtc were running

  • April 15, 2009 at 5:52 pm

    #978533

    ok... I resolved it.

    Even though it's cumbersome to solve.

    I opened the maintenance plan I wanted to delete, clicked "manage connections" and edited the login properties with the new sa password.

    then I was able to delete the maintenance plan after that.

Viewing 11 posts - 1 through 10 (of 10 total)

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