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).
- Is there a way I can check which is the preferred owner of each instance?
- How can I fail back the failed over instance to its preferred owner?