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;
Akshay Narang
AWS, Database, ETL, Integration, Data Reporting & Automation Expert