Friday 17 February 2017

How to set Read routing list in Always on - SQL server 2012

ALTER AVAILABILITY GROUP [AG-NAME]
MODIFY REPLICA ON
N'SERVER1' WITH
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('SERVER3','SERVER2','SERVER4','SERVER5'))); 

No comments:

Post a Comment

Check if column exists or not in the SQL server

--method 1 IF EXISTS(SELECT 1 FROM sys.columns with (nolock)           WHERE Name = N'LoginName'           AND Object_ID = Objec...