Skip to content

Posts from the ‘AlwaysOn’ Category

26
Oct

Remove ReadOnly Routing from a Replica

ALTER AVAILABILITY GROUP [AvailabilityGroupName]
MODIFY REPLICA ON ’ServerName′ WITH(
	PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=NONE)
);