Always On - 如何在此配置中更新SQL Server。 [英] Always On - How to update SQL server in this configuration.

问题描述

Hello，



我们的SharePoint场有两个SQL服务器：它们在2012 SP2版本中我们想要升级到2012 SP4。



是否可以通过"始终开启"逐个更新一个没有影响的机制？我们担心在不同版本的软件中有两个SQL Server服务器，同步会改变数据吗？
b


提前感谢您的帮助，



祝你有个美好的一天，$
克莱门特

解决方案

修补辅助，故障转移，修补另一个节点。

关键是辅助应该是一般的补丁级别高于初级

你也可以ead

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances ？视图= SQL服务器-2017

Hello,

We have two SQL servers for our SharePoint farm: they are in the 2012 SP2 release and we want to upgrade to 2012 SP4.

Is it possible to update one by one with the "always on" a mechanism without impact? We are concerned that with two SQL Server servers in a different version of the software, synchronization alters the data?

Thank you in advance for your help,

Have a good day,
Clement

解决方案

Patch the secondary, Failover, patch the other node.

The key is that the secondary should in General be higher in patch Level than the Primary

Also you can read

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-2017

这篇关于Always On - 如何在此配置中更新SQL Server。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！