Use this to fail over AG's back to the local node.
select 'ALTER AVAILABILITY GROUP ['+name+'] FAILOVER;
go'
from sys.availability_groups
order by name desc
select 'ALTER AVAILABILITY GROUP ['+name+'] FAILOVER;
go'
from sys.availability_groups
order by name desc
No comments:
Post a Comment
Your views:-