Changing schedule of a cloned maintenance plan fails

Posted on 2011-10-27
Last Modified: 2012-05-12
I successfully exported the plans and imported them back in my server. I renamed the maintenance plan in the process, IMPORT-Full_Backup_Plan. The original name of the plan is Full_Backup_Plan.

However, when I try to schedule tbe "cloned" plan, I get this error:
Rename failed for Job Schedule 'Full_Backup_Plan Subplan_1'.
There are several subplans associated with this. Do I need to schedule the individual subplans first and then do the toplevel plan?

Question by:data_bits
    1 Comment
    LVL 15

    Accepted Solution

    Exactly, you must start this from the sub-plans to the top level.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now