Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using SQL Server Management Studio 2005, and I'm about to make changes to the (rather important) Maintenance Plan. I would like to backup (or export) the Maintenance Plan, so it can be restored (or imported) in case the changes made cause any problems.

My Question Is: How can this be done?

I've looked online, and found some people talking about using Integration Services to perform this task. Unfortunately, I do not see an Integration Services utility on the server.

share|improve this question
up vote 2 down vote accepted

This article discusses the steps for migrating a maintenance plan from one server to another. I believe you can use the same procedure to backup your plan before making a change.

share|improve this answer
This is the route I ended up taking. Thanks a lot! – Onion-Knight Apr 29 '11 at 16:11

Beginning in SQL Server 2005 maintenance plans are created as SSIS packages and always stored in MSDB. As long as you're backing up MSDB you'll have your maintenance plan backup.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.