• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 568
  • Last Modified:

SQL 2008 R2 RTM Maintenance Plan - Modification does not take effect

Hi All

Hope quick answer. Modified plan to point backups to new SAN drive, but even after restart SQL SSIS and SQL Agent Svcs, no change is made - still go to local drive. Does one really have to delete and recreate a job to make such a change ?

Thanks to all
  • 2
1 Solution
Aaron ShiloChief Database ArchitectCommented:

basically what you did should have worked.
when you open the maintenance plan with the editor do you see the changes ?
TheGeezer2010Author Commented:
Yes I could see the changes. Needed to get this up and running so have recreated through ssis with correct configuration. Suspect jobs created via wizard may be flaky going to have to pass on the points and close this, but thanks anyway.
TheGeezer2010Author Commented:
Recreated jobs due to time constraints
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now