March 17, 2013 at 4:16 pm
I have setup Always on with four server
Server Role AvilabilityMode Failover Mode ReadabilityMode
Server1 - Primary Syncranized Automatic Failover Yes
Server2 - Secondary Server Syncranized Automatic Failover ReadOnly Intent
Server2 - Secondary Server Syncranized Manual ReadOnly Intent
Server2 - Secondary Server Asynchranized Manual No
I have given two connection string in application one for Readwirte and other for Readonly access and the same is validating
connectionString="Data Source=192.168.1.1\SQL;Initial
Catalog=DBNAME;User
ID=XXXX;Password=XXXX;" providerName="System.Data.SqlClient"
connectionString="Data Source=192.168.1.1\SQL;Initial
Catalog=DBNAME;User
ID=XXXX;Password=XXXX;" providerName="System.Data.SqlClient"
Aplication Inetent=Readonly
Here i have two doubts.
1. Using second connection string which server wil be active for read only ( server2 or server3 ? or Both)
2. If anything happend in my second server inbetween the trasaction what wil happend ?
3. If failover comes to second server is it first server will automatically will readyonly load ?
Thanks in advance
Viewing 0 posts
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