SQL Server AlwaysOn AG Automatic initialization (16)

Summarize

For our production environment to use automatic seed setting considerations:

• Because SQL Server 2016 and 2017 behave differently in disk file path requirements, 2017 can have data files deployed on different volumes on the primary and secondary replicas, so 2017 is more flexible and better suited to our environment.

• For the initialization of the remote and large databases, it is also validated in the production environment.

• Initializes the replica with automatic seeding, which is synchronized with the business database initialization (including log backups).

SQL Server AlwaysOn AG Automatic initialization (16)