Personal Notes of Edwin Eu

Archive for August, 2018|Monthly archive page

How to fix the suspended data movement in MS SQL Server 2016 AlwaysOn Availability Group (AG)

In Microsoft SQL Server on 08/15/2018 at 7:17 AM

How To fix the suspended data movement in MS SQL Server 2016 AlwaysOn Availability Group (AG)

  • Right click the user database
  • Select Resume Data Movement

How to simulate a suspended data movement in SQL Server 2016 AlwaysOn Availability Group (AG)

In Microsoft SQL Server on 08/15/2018 at 7:16 AM

How to simulate a suspended data movement in SQL Server 2016 AlwaysOn Availability Group (AG)

Select one of the user database.

  • First right clicked the user database –> under Available Database à Select Suspend Data Movement
  • Re-launch the Dashboard
  • The Dashboard should show a critical state and several warnings

 

 

 

 

 

 

Click on “Critical and Warning” hyperlink to drill down and see the detail