How to clone a SQL Server 2005 maintenance plan
Posted on 2011-10-10
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.