Skip to content

Archive for

26
Oct

Remove ReadOnly Routing from a Replica

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