Post reply

How to save a Maintenance Paln for re-use?

  • September 9, 2008 at 12:58 pm

    #193328

    Hi,

    I have created a maintenance plan with 3 sub plans, each with a different schedule. As a backup, I would like to script / save this maintenance plan for later re-use or in case I need to rebuild the SQL Server 2005.

    Where is this plan saved or how to script it?

    Thanks in advance for any help.

  • September 9, 2008 at 2:09 pm

    #869290

    Maintenance plans are stored in the msdb database. If you want to move the package you can go to SSMS -> Object Explorer and click Connect -> Integration Services. Then connect to the desired server and go to Stored Packages -> MSDB. Then right-click on the package and select Export Package. In the export dialog select File System for the Package Location and then in Package Path select where you want the package saved. When you are done click OK and you will have a saved .dtsx file that you can open in BIDS and then deploy to another server or edit and re-deploy.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • September 9, 2008 at 2:33 pm

    #869304

    Worked perfectly.

    Thanks very much for your help.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply