Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Migrating Maintenance Plan from One Sql Server 2008 Instance to Another [closed]

I have an extensive maintenence plan on one sql server 2008 instance that I wish to move to 4 other instances. What is the best way to do this other than rebuilding it on each server?

Thanks

like image 464
Josh Avatar asked Jul 23 '10 15:07

Josh


1 Answers

You could try connecting to integration services on the server, expand msdb, maintenance plans and export the plan.

like image 58
SPE109 Avatar answered Sep 19 '22 05:09

SPE109