Blog Pages

Export and Import / move a maintenance plan from one server to other

The maintenance plan stored in the sql server database engine menu under Management --> maintenance plan:


In order to move it to other server, we should do few steps:

1. Connect to the Integration Services of the server where the maintenance plan:


2. Right click on the maintenance plan --> Export Package:


3. Fill the package path (where the dtsx file will be saved) and press OK:


4. Connect to the Integration Services of the server where the maintenance plan will be imported to,
As before – with the same ordering – Right click on the maintenance plan --> Import Package

5. Add the package (press on the "…" button near the pacage path:



That it!

Connect to the database engine and make sure that you see the maintenance plan also there.


Note: if the maintanance plan run from a job – the job should be imported also (of course...).

No comments:

Post a Comment