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