有关从SQL 2016 Alwayson群集添加/删除节点的问题 [英] question on adding/removing Node from SQL 2016 Alwayson cluster

问题描述

您好，我们有一个Production SQL 2016 Alwayson群集，在一个数据中心1和1中有2个节点。 DR站点中的1个节点。数据中心1中的辅助被动节点存在问题。因此，我们计划从群集中删除该被动节点，并添加一个新的
服务器作为辅助被动节点。由于它是被动节点，我认为在删除/添加被动节点时不会有任何停机时间。计划在白天执行该工作。以下是我计划要做的高级步骤：

1。从群集中删除故障被动节点

2。将新的被动节点添加到群集

3。拿一个完整的DB&从活动节点备份 备份

4。停止群集中所有节点中的所有数据库备份作业

5. 使用NORECOVERY将完整数据库备份恢复到新的辅助被动节点

6。使用  NORECOVERY将tran日志备份恢复到新的辅助被动节点

7。同步主要和&之间的登录二级被动节点 

8。配置SQL Alwayson可用性组以添加此新的辅助节点 

9。启动活动&之间的同步过程被动节点

如果上述步骤中遗漏了任何内容，请告诉我。

谢谢。

---

sqldev

解决方案

总是在以下步骤中添加节点

https://www.davidklee。 net / 2012/06/10 / add-new-node-to-sql-server-2012-alwayson-group /

参考自动
生成脚本进行修复将保存您的时间

Hello, we have a Production SQL 2016 Alwayson cluster with 2 nodes in one datacenter1 & 1 node in a DR site. The secondary passive node in datacenter1 is having issues. So we are planning to remove that passive node from the cluster and add a new server as secondary passive node. Since it's a passive node, I don't think there will be any downtime in either removing/adding that passive node. Planning to perform that work during the day time. Here are the high level steps I am planning to do:

1. Remove the faulty passive node from the cluster

2. Add the new passive node to the cluster

3. Take a full DB & tran log backup from the active node

4. Stop all the DB backup jobs in all the nodes of the cluster

5.  Restore the full DB backup with NORECOVERY onto the new secondary passive node

6. Restore the tran log backup with NORECOVERY onto the new secondary passive node

7. Sync up the logins between Primary & secondary Passive node 

8. Configure SQL Alwayson Availability group to add this new secondary node 

9. Start the sync process between the active & passive node

Please let me know if anything is missing from the above steps.

Thanks.

---

sqldev

解决方案

adding node in always on refer following step

https://www.davidklee.net/2012/06/10/add-new-node-to-sql-server-2012-alwayson-group/

refer auto generate script for restoration will save your time

这篇关于有关从SQL 2016 Alwayson群集添加/删除节点的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！