On-Demand Hotfix for Availability Groups in SQL Server 2014

Last week, Microsoft released an on-demand hotfix for SQL Server 2014, which you shgould consider installing if you are using Availability Groups and any of the relevant databases use CLR user-defined types (UDTs). The symptom is described in KB #3042370, and you should get enough info just from the title to convince you to apply it:

The actual hotfix has to be downloaded from a different KB article, KB #3043788. The hotfix will bring SQL Server to version 12.0.2485. As always, please regression test any updates before applying them in production.

For more broad advice about hotfixes and cumulative updates for SQL Server 2014, see this blog post.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)