always on_Always On可用性组中的自动播种

always on

介绍 (Introduction)

In SQL Server Always On Availability Groups, we can add a database into an existing availability group using different methods. We get the following option in the Initial Data Synchronization wizard in SSMS.

在SQL Server始终可用的可用性组中，我们可以使用不同的方法将数据库添加到现有的可用性组中。 我们在SSMS的“初始数据同步”向导中获得以下选项。

• Full Database and Log backup: It starts data synchronization by taking full and log backup for the availability group database. It restores these backups into each secondary replica and joins them to the availability group 完整数据库和日志备份 ：它通过对可用性组数据库进行完整和日志备份来启动数据同步。 它将这些备份还原到每个辅助副本中，并将它们加入可用性组。
• Join Only: If we have taken manual backups and restored them on the secondary server, we can use the Join Only method to add a database into an availability group 仅连接：如果我们已进行了手动备份并将其还原到辅助服务器上，则可以使用“仅连接”方法将数据库添加到可用性组中。
• Skip Initial data synchronization: If we want to perform all database backup manually, restore them on each secondary replica, and join them manually on the secondary replica, we can select this option 跳过初始数据同步：如果我们要手动执行所有数据库备份，在每个辅助副本上还原它们，然后在辅助副本上手动加入它们，则可以选择此选项

Usually, DBA follows up the method Join Only after restoring the backups manually on each secondary replica. This approach is suitable for large databases as well.

通常，在每个辅助副本上手动还原备份之后，DBA都会采用仅连接方法。 这种方法也适用于大型数据库。

SQL Server 2016 introduces a new data synchronization method for databases in Always On Availability Groups – Automatic Seeding or direct seeding

SQL Server 2016为Always On可用性组中的数据库引入了一种新的数据同步方法- 自动 播种或直接 播种

You need to connect SQL Server 2016 or later with SQL Server Management Studio 17.4 or later to see this option. You can still use this feature with the old SSMS version but not with the GUI method. I would recommend installing the latest SSMS version.

您需要将SQL Server 2016或更高版本与SQL Server Management Studio 17.4或更高版本连接才能看到此选项。 您仍然可以在旧版SSMS上使用此功能，但不能在GUI方法上使用。 我建议安装最新的SSMS版本。

In the previous article, SQL Server 2016 Always On Availability Group with Direct Seeding you can take an overview of automatic seeding configuration in Always On Availability Groups using t-SQL scripts. In this article, we will look at a few more aspects along with the GUI method of adding a database into AG.

在上一篇文章SQL Server 2016具有直接播种的Always On可用性组中，您可以使用t-SQL脚本概述AlwaysOn可用性组中的自动播种配置。 在本文中，我们将探讨更多方面以及将数据库添加到AG的GUI方法。

Environment prerequisites:

环境先决条件：

• SQL Server 2016 or latest version
  SQL Server 2016或最新版本
• SSMS 17.4 or later
  SSMS 17.4或更高版本
• A database should have a full database backup to meet prerequisites at the database level. If you created a new database, take a full back up before proceeding for the next step

  </