Patching SQL Server Failover Cluster Instances with Cluster-Aware Updating (CAU)
SQL Server Technical Article
Summary: This paper describes the process of applying software updates on SQL Server 2012 failover cluster instances by using the Cluster-Aware Updating (CAU) feature that is available in Windows Server 2012. CAU's update scheduling features and Windows PowerShell Cluster-Aware Updating-specific cmdlets (http://technet.microsoft.com/en-us/library/hh847221.aspx) provide a very rich and flexible set of capabilities that can eliminate the lengthy manual processes that are usually required when applying updates to SQL Server failover cluster instances. Samples and demonstrations in this paper use SQL Server 2012 Service Pack 1 as the software update being applied as it is the first Microsoft SQL Server update that supports CAU.
For more information on CAU, see Cluster-Aware Updating Overview. The "Additional Resources" section of this paper also provides links to the CAU documentation.
Writers: Dhawa Ngoche
Technical Reviewers: Gail Erickson, Shamik Gosh, Russell Green, Tim Wong, Min He
Published: January 2013
Applies to: SQL Server 2012 on Windows Server 2012