February 4, 2018 at 8:06 am
Comments posted to this topic are about the item Configure Read Only Routing
Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com
February 5, 2018 at 6:43 am
SQL Server Management Studio 17.3 added support for Read-Only Routing:
February 5, 2018 at 7:08 am
thanks for posting and sharing information.
Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com
February 5, 2018 at 9:41 am
if you're going to all the trouble of first opening the AG properties and setting the secondaries to Read_Intent, then you do not need to run this part of the script for each replica
ALTER AVAILABILITY GROUP [AGTEST01] MODIFY REPLICA ON N'DB2' WITH (SECONDARY_ROLE (ALLOW_CONNECTIONS = READ_ONLY));
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs"
March 19, 2018 at 4:01 am
How can i configure it without DOMAIN ?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy