Need expert help to setup maintenance plan on multi instance cluster

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » Need expert help to setup maintenance plan on...

Need expert help to setup maintenance plan on multi instance cluster

Rate Topic

Display Mode

Topic Options

Author

Message

CuriousDBA

Posted Sunday, November 04, 2012 11:16 AM

Grasshopper

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

Perry Whittle

Posted Monday, November 05, 2012 6:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:15 PM
Points: 5,204, Visits: 11,162

CuriousDBA (11/4/2012)

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

Post #1381050

« Prev Topic | Next Topic »

Permissions