In some cases it is needed to determine which server is Active manager for DAG and move it away.
- Determine which server is active manager
We can use two ways. Powershell or command line cmdlets.
In PowerShell we can use cmdlet:
Get-DatabaseAvailabilityGroup -status | select PrimaryActiveManager
and parameter -Status is needed to gather current state of DAG.
In CMDline we need to be logged on the server, which is part of DAG or has Windows clustering installed. Then the commad line is simple:
Move active manager
easiest way is to use cluster command:
cluster group "cluster group" /move:TARGETMACHINE