To set up similar plans, you do not necessarily have to start from scratch. Create a plan and copy it to any server instances where you want the plan to run.
NOTE: Copying and importing plans and subplans between servers may require additional manual steps, if the source and target servers have:
Different SQL Server versions—You may need to review and edit the selected databases list. Back Up Databases Using Maintenance Plans
Also, when copying a subplan between SQL Server 2005 (or higher) and SQL Server 2000, multiple Backup Database and Fast Compression (SmartDiff) Backup tasks are not copied due to the difference between the SSIS and legacy plans. For legacy plans, you cannot have more than one Backup task in a subplan. You may want to create a new subplan and add a backup task to this subplan.
Different LiteSpeed versions and different SQL Server versions—Back Up Databases Using Maintenance Plans
- LiteSpeed versions on the source and the target are different, but database lists are the same.
- LiteSpeed version is the same but the database list is different (warning indicates that some databases do not exist).
- LiteSpeed versions and database lists are different.
To copy a maintenance plan
To copy a subplan
To export or import a maintenance plan
To export or import a subplan