November 25, 2018 at 11:31 pm
Hi all,
Server Names : SQL01 and SQL02, SQL01\int01 and SQL02\int02
SQL02 and SQL02\int02 was primary, at the same time SQL services for SQL01\int01 was stopped and failover occurred,
hence SQL01 becomes primary and SQL02 is Secondary, but for named instance SQL02\int02 is still primary and while bringing SQL services UP - SQL01\int01 is now secondary.
If I failover SQL02\int02 instance, do my default instance also roles get changes?, does WSFC works individually for SQL Serves?
Thanks in advance...!
November 27, 2018 at 6:31 am
Shree_L - Sunday, November 25, 2018 11:31 PMSQL services for SQL01\int01 was stopped and failover occurred,
hence SQL01 becomes primary and SQL02 is Secondary
This doesn't make sense to me. If you stopped the service for the named instance, how did it become the primary?
November 27, 2018 at 6:50 am
Beatrix Kiddo - Tuesday, November 27, 2018 6:31 AMShree_L - Sunday, November 25, 2018 11:31 PMSQL services for SQL01\int01 was stopped and failover occurred,
hence SQL01 becomes primary and SQL02 is SecondaryThis doesn't make sense to me. If you stopped the service for the named instance, how did it become the primary?
Doesn't make sense agreed. If it was on 01 and then failed over to 02. I would check if you have it to automatically failover within SQL
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply