Re: Sql 2005 can't update maintenance plans?

I've added databases to maintenance plans and the newly added databases are
being processed. It's more trouble than it was in SQL2K since you have to
edit each of the maintenance plan's lower-level tasks. In SQL2K you could
set the databases as a general property of the entire maintenance plan.
After making the edits, you have to explicitly save the changes before
closing the editor.
Paul Shapiro

"frostbb" <frostbb@xxxxxxxxxxxxxxxxx> wrote in message
news:OntzaWDpGHA.1592@xxxxxxxxxxxxxxxxxxxxxxx
Dan English posted the message below on Jan 24. Looks like the thread has
been expired from the microsoft.public.sqlserver.server news group.

I'm experiencing the same problem.

I'm wondering if a workaround for this issue has been published ?? <<
I would expect that a system stored proc is getting triggered correctly
after the update [ok] button is mashed.

Haven't had any luck finding further mention of this issue with my Google
searches since the return to "+2005 +"Maintenance Plan" +Changes" returns
a huge number of non-related hits.

Everytime we add a new database to our server I have to physically delete
and recreate my Full, Differential and Transaction Log backup maintenance
plans. To say the least it's a PIA ... although since we're in the middle
of a migration from a Unix to Sql Server platflom I can basically recreate
the plans in my sleep by this time. Regardless its very frustrating that
SSIS objects reflect the change but don't actually physically implement
the changes.

Thanks in advance.

Barry
in Oregon

==============================================================================

From:Dan English
Date:Tues, Jan 24 2006 10:42 am
Email: "Dan English" <dan_engli...@xxxxxxx>
Groups: microsoft.public.sqlserver.server

I created a couple of maintenance plans in Sql 2005 and they run fine.
When
I edit them and make changes though, the changes seem to be saved but they
don't get executed. It seems I have to delete the entire plan and
recreate
it to make changes. Has anyone else noticed this?


.

Loading