How to Transfer (Copy) Maintenance Plans from One Server to Other?


I’m going to show how maintenance plans can be copied over from one SQL Server to another. If you are not aware, Maintenance Plans are nothing but SSIS packages which SQL Server creates behind the scenes and deploy them under MSDB Database as you can see below.

How to Transfer (Copy) Maintenance Plans from One Server to Other

I’ve created a Maintenance Plan (Test_Maint) in my Prod Instance and connected to local SSIS, as you can see in the above screenshot SQL automatically created an SSIS package with the same name and deployed under MSDB. So to Copy this Maintenance Plan to another Server, all you need to do is just Right click on the package and Export to FileSystem. Now, copy the DTSX file(Actual SSIS package) to the new server and you can deploy under MSDB->Maintenance Plans Node by importing it.

Follow the below Screenshots in the same order.

How to Transfer (Copy) Maintenance Plans from One Server to Other

Save in File System as shown below.

How to Transfer (Copy) Maintenance Plans from One Server to Other

Now, connect to new Server and Import the package as shown below.

How to Transfer (Copy) Maintenance Plans from One Server to Other

How to Transfer (Copy) Maintenance Plans from One Server to Other

Click Ok…and Connect to Database Engine and Expand your Management->Maintenance Plan Node to Verify Package being created.


<<Click here to see all posts>>

If you found any of the information on this page helpful in anyway then please consider sharing this content with your favorite social network or by leaving your thoughts in the comment section. Thanks!

Leave a Reply

Your email address will not be published. Required fields are marked *

Prove You Are Human Time limit is exhausted. Please reload CAPTCHA.