Need expert help to setup maintenance plan on multi instance cluster

  • 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

  • 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" 😉

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

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