0

I've inherited a few Windows servers with SQL Server installed. Some of them are in failover cluster which is perfect in case of outages.

However I do not have much experience with SQL Server management and I have a few questions which might sound dumb to someone but please excuse me.

There is failover configured between those SQL Servers and when one is out, the instance preferred owner is being changed to the one that's available. However it doesn't have a failback and when the main SQL Server is up the instances are not being changed to the main server.

The cluster is using failover cluster instances (not availability groups).

Questions

  1. Is there a way I can check which is the preferred owner of each instance?
  2. How can I fail back the failed over instance to its preferred owner?
New contributor
joniop is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Your Answer

joniop is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.