How to transfer a maintnenance plan from one server to another?

Hi there,

I have setup serveral maintenance plans on my design server and I now want to roll them out to the development, test, production servers.

Can I export the maintenance plan and then import it to another server?
LVL 1
sqlconsumerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
zx10rConnect With a Mentor Commented:
check this out http://sqlserver-qa.net/blogs/tools/archive/2007/10/15/copy-db-maint-plans.aspx

All the maintenance plans are stored in MSDB, just like most SSIS packages are. Just export them from there and import to you desired server
0
 
MikeWalshConnect With a Mentor Commented:
In SQL Server 2005 you can import/export maintenance plans through SSIS (SQL Server Integration Services) which is the tool that SQL is using to create maintenance plans. Connect to integration services, look for the packages that are stored in MSDB and you should be able to browse to your maintenance plan and select import/export.
0
 
MikeWalshCommented:
Here is a link that explains it a bit better

http://forums.microsoft.com/MSDN/showpost.aspx?postid=389484&siteid=1
0
 
sqlconsumerAuthor Commented:
Yep I just figured than one out, now I'm trying to export/import the schedules and operators.

Got any ideas?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.