How to Create Maintenance Plans on SQL Server Failover 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 » How to Create Maintenance Plans on SQL Server...

How to Create Maintenance Plans on SQL Server Failover Cluster

Rate Topic

Display Mode

Topic Options

Author

Message

CuriousDBA

Posted Thursday, January 03, 2013 2:38 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:41 PM
Points: 11, Visits: 60

We have configured a 2 node SQL Server Failover cluster on SQL Server 2008 R2 recently. I am curious to know whether maintenance plans are supported on failover cluster or not?

Maintenance plans are cluster aware?

If we create some maintenance plan on failover cluster, how the cluster handle these plans during automatic failover?

Thanks in Advance

Post #1402251

Grant Fritchey

Posted Thursday, January 03, 2013 3:58 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:09 PM
Points: 13,383, Visits: 25,187

Maintenance plans and SQL Agent jobs are stored within the system databases on the your server. So, with a failover cluster where the databases are the shared item between the servers, anything on them is also shared. You don't have to worry about maintenance plans or Agent Jobs. Just make sure you are using the cluster server name and not the individual machine names in any scripts or maintenance steps you create and you should be fine.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1402276

« Prev Topic | Next Topic »

Permissions