Issue:Secondary database server instance was showing “Not Synchronizing” for all the replica database on secondary node.

Cause:After checking found that the database copies in secondary node were paused.

Resolution: To resume the replica database from secondary node using SQL Management studio follow the below.

  1. In Object Explorer, connect to the secondary server instance that hosts the availability replica on which you want to resume a database, and expand the server tree.
  2. Expand the Always On High Availability node and the Availability Groups node.
  3. Expand the availability group.
  4. Expand the Availability Databases node, right-click the database, and click Resume Data Movement.
  5. In the Resume Data Movement dialog box, click OK.
  6. Repeat steps 4 and 5 for each database.

Using Powershell:

  • Change directory (cd) to the server instance that hosts the replica whose database you want to resume. For more information, see Prerequisites, earlier in this topic.
  • Use the Resume-SqlAvailabilityDatabase cmdlet to resume the availability group.

Example:

Resume-SqlAvailabilityDatabase ` -Path SQLSERVER:\Sql\Computer\Instance\AvailabilityGroups\MyAg\Databases\MyDb3

Reference: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/resume-an-availability-database-sql-server?view=sql-server-ver15

RELATED ARTICLESMORE FROM AUTHOR