您可以在AG复制过程中使用主SQL服务器吗？ [英] Can you use the primary SQL server during AG replication process?

问题描述

您可以在AG复制过程中使用主SQL服务器吗？

我们计划为SQL AG创建两个或更多副本。   我们可以在将数据库添加到复制和异步AG中的所有副本的过程中使用主节点吗？   换句话说，我们有一个非常大的数据库
，超过4 TB，我想知道如果我们可以添加到一个四节点SQL AG，如果我们可以将我们的应用程序连接到主节点，同时副本将进入同步？   请注意，我们是第一次将此数据库添加到此AG。

---

dsk

解决方案

您好，

是的，您可以连接到主要在添加新节点时进行查询。 在数据传输到新节点时，这不会以任何方式关闭数据库，因此您可以继续正常使用它。

您可能会注意到这项工作会导致性能下降提前（因为它就像在初始播种期间从主要部分进行备份），但它仍然有效。

我会安排这个安静的时间来开始工作虽然上述原因。

谢谢，

马特

Can you use the primary SQL server during AG replication process?

We are planning on creating a two or more replicas for SQL AG.   Can we use the primary node during the process of adding the databases to the replication and asynch all the replicas in the AG?   In other words, we have a very large database which is over 4 TB and am wondering if we add to a four node SQL AG if we can connect our application to the primary node while the replicas are going into synch?   Note that we are adding this database for the first time to this AG.

---

dsk

解决方案

Hi,

Yes, you can connect to the primary for queries whilst the new node is added.  This does not take the database down in any way whilst the data is transferred to the new node, so you continue to use it as normal.

You may notice some performance degradation whilst this work goes ahead (as it will be like taking a backup from the primary during the initial seeding), but it will still work.

I would schedule this for a quiet time to start the work though for the above reason.

Thanks,

Matt

这篇关于您可以在AG复制过程中使用主SQL服务器吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！