Post reply

How to generate Scripts of Maintinanace Plan Tasks

  • November 24, 2011 at 11:59 pm

    #248546

    We have configured some Maintenance tasks(BackUp Database Task, Reorganize Index Task, Rebuild Intex Task). Sometime we need to reinstall SQL Server. After Installation we need to reconfigure all thses tasks.

    We are using SQL Server 2008R2.

    Is there any way to generate scripts like replication of all these tasks to avoid reconfiguration and extra work?

    Thanks

    Azhar

  • November 25, 2011 at 1:46 am

    #1412886

    Maintenance plans are stored as SSIS packages. They can be exported and saved to file system/SQL Server.

    Follow the below steps:

    1. Connect to Integration Services of the SQL Server that has the maintenance plans

    2. Select Stored Packages --> MSDB --> Maintenance Plans

    3. Right click the required maintenance plan and Select Export Package and save to File System

    4. In a new server, go to Integration services and select Stored Packages --> MSDB --> Maintenance Plans

    5. Select Import Package from File System (path of the saved file). The maintenance plan will get created in the new server.

  • November 25, 2011 at 4:27 am

    #1412950

    Thanks its Works for me.

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

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