Post reply

How Do You Delete A Maint Plan Task Connection No Longer In Use

  • September 9, 2010 at 9:02 am

    #238046

    Hi Folks

    I have some Maint Plans in SSMS that have more than one available Connection for a Task in a Maintenance PLan. I do not see anywhere where you can delete the connection(s) you no longer need. Does anyone know what I need to do to remove the connections no longer needed ?

    Thanks

    Jim

  • September 9, 2010 at 10:37 am

    #1218777

    Did you click the "Manage Connections" in the maint plan editor? There's a "remove" button. (see attached)

  • September 9, 2010 at 10:58 am

    #1218802

    Hi Stsve

    i do not see a Main Plan Editor in SSMS

    where is it ?

    Jim

  • September 13, 2010 at 10:22 am

    #1220176

    Anybody ?

  • September 13, 2010 at 10:25 am

    #1220178

    Under Management, there should be a "Maintenance plans" folder. Click it, then double click your plan. It should open in an editor.

  • September 13, 2010 at 10:34 am

    #1220181

    Hi Steve

    found it

    I kept clicking the pull down arrow for Manage Connections instead of clicking the button

    Thanks

    Jim

  • September 13, 2010 at 10:43 am

    #1220188

    Hi Steve

    another issue i just saw

    i was trying to edit the "Local server connection" and cannot

    i had copied this maint plan over from s80 server to ss73 server

    i added a "Local Server Connection" for ss73 because sql server did not change the server to the server i was now on and retained the old server for "Local server connection"

    any advise on how to fix this issue?

    Thanks

    Jim

  • September 13, 2010 at 12:02 pm

    #1220228

    Is there perhaps a task in the package using this connection?

    I don't have a 2005 instance to check this on right now, but can you save/store this in the file system and then flip through the XML, looking for the old connection?

  • September 13, 2010 at 12:40 pm

    #1220260

    Thanks Steve

    appreciate the info

    Jim

Viewing 9 posts - 1 through 8 (of 8 total)

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