Skip to main content
Version: v23.0

Automatic Seeding for Availability Groups

Summary

Adding a database to an availability group may experience problems seeding to the secondary replica.

Information

Use the following steps to try and re-initiate seeding for the database.

  1. Check that the SQL Server instance is running on each node.

  2. Wait a few minutes for the replica to seed the database. If after a few minutes the database has still not seeded, then restart the SQL Server instance on the secondary replica(s).

  3. In DxAdmin, right-click on the secondary replica under the availability group Vhost and select Resync secondary.

  4. Run the following query on the primary replica:

    ALTER AVAILABILITY GROUP <ag_name> MODIFY REPLICA ON '<secondary_replica>' WITH ( SEEDING_MODE = AUTOMATIC );

Additional Information