Thursday, January 03, 2013 9:44 AM
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
Thursday, January 03, 2013 10:02 AM
Maintenance Plans are of course supported. Technically they are nothing more than SQL Agent jobs which are stored in MSDB. In a clustered environment the Agent will always be running on the active instance, and so will MSDB. So for the maintenance plans there is nothing special to consider.
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Thursday, January 03, 2013 1:40 PM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Monday, January 14, 2013 2:13 PM
Thursday, January 03, 2013 1:41 PM
You don't have to worry about maintenance plan been on failover cluster.
Maintenance plan are handled on clustered instance the same way as on standalone instances. Maintenance plan are handled by SQL Server Agent service & msdb database, so when failover happens to other node then SQL Server Agent Service resource also moves other node & maintenance plans/jobs runs from that node.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful, if a post was useful to help other user's find a solution quicker.
Thursday, January 03, 2013 10:23 PM
to clear your doubt you need to know the activity behind scene. FCI (Failover cluster instance) is a single point of failure, means the shared disk simply fails to the other node.
If you create a Maintenance plan on one node that information is stored in MSDB of that instance. The disk that hold this information is in sync with the disk that is available to other node. when failover happens this information is available to the instance on other node.
i hope you get my point.cheers