question

Raju007 avatar image
Raju007 asked

SQL 2016 Always on preferred owner selection not working

I have configured 4 node cluster (2 DC and 2 DR) and configured SQL 2016 AlwaysOn feature. I set the preferred owner to DB1, DB2, DB3 and DB4 is manual failover. When I check automatic failover, only for first time it goes to DB2 then DB3 but next time it has gone to DB1 then DB3 not in DB2. I want every time it will switch to DB1 then DB2 finally DB3. which settings it will win my goal. Thanks,
sql-server-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.