one pause a SQL server 2016 nodes on a AOG group, listener don't failover.

hi,

from SQL configuration manager I accidentally click pause SQL server service, for one of the SQL 2016 AOG SQL nodes,  then AOG listener still connect to that node and therefore SQL server can't connect anymore.

AOG in this case, don't failover to other node, any reason for that?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
It depends if you've configured it for automatic or manual failover. I'll guess that if it didn't failover automatically then it's set to manual failover.
0
marrowyungSenior Technical architecture (Data)Author Commented:
but what I tried is, when I restart one SQL node it failvoer automatically and this means auto failover is working fine.

so why ..
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Restarting the SQL Server service won't make the Listener cluster resource to failover.
Restarting the server where the Listener is active in the cluster node, it will make it failover to the next available node.
That's why.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

marrowyungSenior Technical architecture (Data)Author Commented:
"Restarting the server where the Listener is active in the cluster node, it will make it failover to the next available node."

I restart the active node and it failover to the other node, but my question is I also paused the active node but it don't failover..
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Pause isn't the same as failover, isn't it?
0
marrowyungSenior Technical architecture (Data)Author Commented:
what I want to try is, actually I found the pause of SQL node stop the service and therefore service will stop, under this situation who AOG and WSFC handle it.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't know how to pause a cluster node. Do you mean putting a cluster resource offline?
0
marrowyungSenior Technical architecture (Data)Author Commented:
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok, that's new for me. Never used it so I don't really know what's the impact of a Pause action.
0
marrowyungSenior Technical architecture (Data)Author Commented:
this feature means remove service sit on top of that nodes before failover, I can't see why we need it.


WSFC will handle this for us when failover, specially by sth called dependency....
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Do you still need help on this question or it can be closed?
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 10

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.