How do I transfer my maintenance plan from one server to another?

How do I transfer my maintenance plan from one server to another?

To do this, navigate to Stored Packages > MSDB > Maintenance Plans in the object explorer. Right click the BackupFull maintenance plan and select Export Package as shown below. After clicking Export Package a dialog box ‘Export Package’ will open.

How do I copy SQL Server maintenance plan to another server?

Connect to the Integration Services instance, rather than the database instance, expand Stored Packages > MSDB > Maintenance Plans, and right-click any plan and choose Export package. On the other server, follow the same steps, but right-click Maintenance Plans and choose Import package.

Can you copy a maintenance plan from one server to another?

Update: Don’t copy or transfer Maintenance Plans. Create new ones Instead if needed or checkout Ola Hallengren’s Maintenance solution or Minionware suite. This would be a very short blog post where I’m going to show how maintenance plans can be copied over from one SQL Server to another.

How to transfer SQL server maintenance plans between servers?

In conclusion, maintenance plans can be moved between servers by using SQL Server Integration Services. The SSIS allows importing as well as exporting packages to the server. As each maintenance plan itself is a SSIS package, it can be easily transferred via SSIS. To find more information about the discussed topic, please follow the links below:

How to export maintenance plans to another database?

You may have to take additional steps, depending on what the plans do. Connect to the Integration Services instance, rather than the database instance, expand Stored Packages > MSDB > Maintenance Plans, and right-click any plan and choose Export package.

How to import maintenance plan on destination server?

To import the maintenance plan on the destination server, connect to the Integration Services catalog on the destination server and navigate to Maintenance Plans as explained before. Now, right click on Maintenance Plan and select Import Package as shown in the below image. After clicking import package, a dialog box ‘Import Package’ will open.