Pausing the secondary Replicas for a day in always on availability group

by user9394033   Last Updated September 07, 2018 16:06 PM

We are planning to make the DR as primary and do maintenance on the secondary site(Formerly Primary Site) and hence pausing both the secondaries in always on availability group for a day. I am aware that if both the secondaries are paused then there wont be any failover, but will there be any other problems of pausing the secondaries for a day ...Am i missing something ? Any help will be greatly appreciated !

Can i safely go to the Failover cluster manager and paused both the secondary nodes ?



Answers 1


...but will there be any other problems of pausing the secondaries for a day ...

"It depends" but in general, yes. the non-complete list of items:

  • No transaction log truncation on the primary
  • Primary send queue will be large
  • Log caches will become large and may end up consuming more memory than you'd like...
  • Which could cause memory pressure, buffer pool, etc. issues
  • When the connection reconnects it'll need to send all the outstanding data, which it may not ever catch up

Now, this seems pretty grim, however, if the amount of traffic is normally pretty low (which you can guesstimate by looking at your transaction log backup size history) then you might be able to get away with it.

If, however, the amount is very large then you might just want to remove it from the Availability Group, do your maintenance, replay the logs when you bring it back up, and join it back in.

Can i safely go to the Failover cluster manager and paused both the secondary nodes ?

You could but that won't affect SQL Server. You'll need to work with SQL Server through T-SQL or SMO. Pausing the node will only cause you more problems on the primary, but pausing the node on the secondary will tell the WSFC to not move any resources over (which won't happen anyway but this won't hurt anything).

Sean Gallardy
Sean Gallardy
September 07, 2018 15:26 PM

Related Questions


Failover from Primary to Asyn Secondary Replica

Updated August 23, 2018 16:06 PM

AAG expansion between datacenters

Updated February 17, 2017 16:06 PM

Problems of having DR as Synchronous Commit

Updated August 28, 2018 14:06 PM

Always On -Stand Alones

Updated May 08, 2016 08:02 AM