See Automatically initialize Always On Availability group. Available on SQL Server 2016 (13.x) and later. Automatic seeding requires that the data and log file paths are the same on every SQL Server instance participating in the group.
SQL Server automatically creates the secondary replicas for every database in the group. If your backup and restore operations must be highly secured, we recommend that you select either the Join only or Skip initial data synchronization option. Also, to protect your backup and restore operations, we recommend that you secure the network channels between every server instance that hosts an availability replica and the network share folder. This precaution is important because potentially sensitive data in the backup file can be accessed by anyone who has a READ permission on the folder. Before you use a wizard to perform full initial data synchronization, we recommend that you implement a security plan for the access permissions on the network share folder. For more information, see To Prepare Secondary Databases Manually, later in this topic.įull initial data synchronization requires you to specify a network share. In such cases, we recommend that you prepare secondary databases yourself. Suspend log backup tasks for the primary databases during initial data synchronization.įor large database, full backup and restore operations can take extensive time and resources. Before you select Automatic seeding, Full, or Join only ensure that your environment meets the prerequisites.
The possible choices include Automatic seeding, Full database and log backup, Join only, or Skip initial data synchronization. This page is shared by three wizards-the New Availability Group Wizard, the Add Replica to Availability Group Wizard, and the Add Database to Availability Group Wizard. Use the Always On Select Initial Data Synchronization page to indicate your preference for initial data synchronization of new secondary databases.
0 kommentar(er)
