What is the easiest way to copy more than 50 sql agent jobs from one sqlserver to another. What is the process of copying all Maintenance plan from one server to another.
What is the easiest way to copy more than 50 sql agent jobs from one sqlserver to another. What is the process of copying all Maintenance plan from one server to another.
I highly recommend against copying maintenance plans between servers. They are SSIS packages which contain connection string, etc which all need to be fixed after the copy.
It is best to setup new maintenance plans on new servers manually, or don't use maintenance plans at all and use Ola's scripts instead https://ola.hallengren.com/ They are much more flexible.
13 people are following this question.