How to Create Maintenance Plans on SQL Server Failover Cluster

  • 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

  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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