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