Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Need expert help to setup maintenance plan on multi instance cluster Expand / Collapse
Author
Message
Posted Sunday, November 4, 2012 11:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:41 PM
Points: 11, Visits: 60
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
Post #1380804
Posted Monday, November 5, 2012 6:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 6,365, Visits: 13,695
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"
Post #1381050
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse