Home Forums SQL Server 2008 SQL Server 2008 High Availability Need expert help to setup maintenance plan on multi instance cluster RE: Need expert help to setup maintenance plan on multi instance cluster

  • November 5, 2012 at 6:37 am

    #1556022

    CuriousDBA (11/4/2012)

    I am new to cluster environment, wanted to setup some daily maintenance Plan on Dynamics AX SQL Server 2008 cluster (Multi Instance - 2 nodes).

    I have created maintenance plans on standalone server; can I follow same method on a cluster?

    Do I need to install SSIS to create maintenance plan on a cluster?

    Please guide me

    Thanks in advance

    The maintenance plans and any agent jobs are created at the instance level and are carried over during a failover of the SQL Server instance

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉