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