How to clone a SQL Server 2005 maintenance plan

Posted on 2011-10-10
Last Modified: 2012-06-22
I'm new to SQL Server and have inherited a SQL Server environment with several maintenance plans already in place. Some of the plans are quite complicated. I'd like to make a duplicate of the one the plans and make changes to the copy. If the changes don't work as intended, I'll have the original that I can continue to use.

Is this possible? I didn't see an obvious way in SSMS to copy/clone a maintenance plan.


Question by:data_bits
    LVL 25

    Accepted Solution


    Author Comment

    The problem is that the Integration Services are not installed on the source SQL Server.

    Author Comment

    I got Integration Services installed and can get to the point where I can export the maintenance plan. The next question has to do with the export package wizard.

    It asks for the "Package path", after entering the Package location (SQL Server), and the Server name.
    Is this a path where is will export the package to? If I enter E:\Backups\Exports, will it export it to that folder on the E-drive?

    Or is it a name that I give it?

    Author Comment

    I successfully exported the plans and imported them back in my server. I renamed it 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?

    Can you help?

    Author Closing Comment

    Wanted more detail and response to questions

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now