alwayson高可用组
In continuation to the part 1, on how to setup a SQL Server Availability Groups, let’s now check how to create the Availability Group itself and put the databases in sync.
继续第1部分 (关于如何设置SQL Server可用性组)的内容,现在让我们检查如何创建可用性组本身并使数据库同步。
For this purpose, we will be using the “New Availability Group” wizard. To access this option, expand the “AlwaysOn High Availability” node and right click the “Availability Groups” folder.
为此,我们将使用“新可用性组”向导。 要访问此选项,请展开“ AlwaysOn High Availability”节点,然后右键单击“ Availability Groups”文件夹。
A new window will be presented, with a summary of in what the wizard will help us. You can see an example in the next image.
将显示一个新窗口,其中概述了向导将帮助我们的内容。 您可以在下一张图片中看到一个示例。
Click “Next” to proceed, and let’s start the actual configuration. In the first step we need to input an Availability Group name. This is just a name to help us identify a group, nothing related with the listener.
单击“下一步”继续,让我们开始实际配置。 在第一步中,我们需要输入一个可用性组名称。 这只是一个名称,可以帮助我们识别组,而与侦听器无关。
I will be using the name “AgHowTo” in order to demonstrate all the steps to follow. Fill the name, as desired, and click “Next”.
我将使用名称“ AgHowTo”来演示要执行的所有步骤。 根据需要填写名称,然后单击“下一步”。
On this second step, we will be asked to select all the databases that we want to include in our Availability Group.
在第二步中,将要求我们选择要包含在可用性组中的所有数据库。
Notice that there’s a column “Status” where the message “Met the prerequisites” is being shown. To meet the prerequisites, the wizard means that our d