tags:

views:

60

answers:

1
Q: 

Migrating Maintenance Plan from One Sql Server 2008 Instance to Another

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

+1  A: 

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

SPE109  2010-07-26 17:57:47

related questions

Ruby on Rails Migration - Create New Database Schema
Best way to really grok Java for a C# guy
How can I quickly identify most recently modified stored procedures in SQL Server
Migrating an Existing Application to accept Unicode.
Moving SQL2005 app to SQL2008
How good are the tools to migrate to and from Team System?
rake db:migrate doesn't detect new migration ?
How to upgrade database schema built with an ORM tool?
Rails model validators break earlier migrations
What tools exist to convert a Delphi 7 application to C# and the .Net framework?
Recommendation on Tools to migrate from Clearcase to SVN?
What’s the best approach when migrating legacy projects across versions of visual studio?
What is th easiest way to copy a database from one Informix IDS 11 Server to another
Migrating database changes from development to live
Convert Web.config from .NET 2.0 to 3.5
Migrating from ASP Classic to .NET and pain mitigation
Visual Source Safe --> TFS Migration
C# for Java Developer
Quick easy way to migrate SQLite3 to MySQL?
Migrating from MySQL to PostgreSQL
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
Database Migration library for .NET
PHP4 to PHP5 Migration
Mechanisms for tracking DB schema changes
Upgrading SQL Server 6.5