locked
Is SSIS Installation required to create Maintenance Plan ? RRS feed

  • Question

  • Hi all

    I want  create Maintenance Plans  in SQL Server 2005 Cluster?

    Is it reqired SSIS installation.

    Thanks in Advance

     


    SNIVAS
    Tuesday, July 20, 2010 7:40 AM

Answers

All replies

  • No


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, July 20, 2010 7:46 AM
  • Hi SNIVAS,

     

    We don’t need to install SQL Server Integration Services (SSIS).

     

    We could create a plan using the Maintenance Plan Wizard. About how to create a maintenance plan using the Maintenance Plan Wizard, please see the following steps:

        1. In Object Explorer, expand a server, and then expand Management.

        2. Right-click Maintenance Plans and select Maintenance Plan Wizard.

        3. Follow the steps of the wizard to create a maintenance plan.

     

    For more information about how to create a maintenance plan, please visit the following link:

    http://msdn.microsoft.com/en-us/library/ms189953.aspx

     

    If you have any more questions, please feel free to let me know.

     

    Thanks,

    Yoyo Yu

    Thursday, July 22, 2010 2:46 AM
  • Thanks Yoyo Yu

    As your suggestion I open maintenance Plan  Created new maintenance Plan.

    after that

    1.I Drag and dropped "Backup Database Task" Maintenance Plan,

    2.Did required changes (Selected all database) for Backup

    3.Click on Save icon

    It is showing an error "Guid should contain 32 digits with 4 dashes (xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx).

    how to solve this error.

     


    SNIVAS
    Thursday, July 22, 2010 9:33 AM
  • SQL Server 2005 with Service Pack 2 and above does not require SSIS to be installed for creating of Maintenance plans.

    SQL Server 2008 with Service Pack 1 or Cumulative Update 3.

    Source:

    FIX: Error message when you run a maintenance plan in SQL Server 2008: "The SQL Server Execute Package Utility requires Integration Services to be installed"

    Do maintenance plans require SSIS?

    Do we need SSIS to create Maintenance Plan


    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Proposed as answer by TiborKMVP Friday, July 23, 2010 2:45 AM
    • Marked as answer by SNIVAS Friday, July 23, 2010 10:30 AM
    Thursday, July 22, 2010 10:01 AM