Sql 2005 can't update maintenance plans?
- From: "frostbb" <frostbb@xxxxxxxxxxxxxxxxx>
- Date: Mon, 10 Jul 2006 08:28:53 -0700
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?
.
- Follow-Ups:
- Re: Sql 2005 can't update maintenance plans?
- From: Paul Shapiro
- Re: Sql 2005 can't update maintenance plans?
- Prev by Date: Re: Unused indexes
- Next by Date: Re: Sql 2005 can't update maintenance plans?
- Previous by thread: Re: Unused indexes
- Next by thread: Re: Sql 2005 can't update maintenance plans?
- Index(es):
Loading