Suspend & Resume Always on AG Group Sync

 

Suspend Sync

Go to Primary Node

Execute below dynamic query:

select 'ALTER DATABASE ['+DB_name(database_id)+'] SET HADR SUSPEND;' from master.sys.dm_hadr_database_replica_states where is_local = 1

For example, it will show the below result. Copy the below line and execute.

ALTER DATABASE [AAA] SET HADR SUSPEND;

ALTER DATABASE [BBB] SET HADR SUSPEND;

 

Resume Sync

Go to Primary Node

Execute below dynamic query:

select 'ALTER DATABASE ['+DB_name(database_id)+'] SET HADR RESUME;' from master.sys.dm_hadr_database_replica_states where is_local = 1

For example, it will show the below result. Copy the below lines and execute.

ALTER DATABASE [AAA] SET HADR RESUME;

ALTER DATABASE [BBB] SET HADR RESUME;