How to clone a SQL Server 2005 maintenance plan

Posted on 2011-10-10
Medium Priority
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
  • 4
LVL 25

Accepted Solution

jogos earned 750 total points
ID: 36946201

Author Comment

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

Author Comment

ID: 37008457
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

ID: 37038356
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

ID: 37178173
Wanted more detail and response to questions

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

807 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