December 14, 2020 at 6:21 am
Dear all,
I didn't find anything about this so here I go:
On page 31 in Licensing Guide there is one sentence which is bugging me
I understand it this way: We have a Windows Server 2 node cluster with 4 instances running on it and we have to make sure, that if one instance moves, all other instances must also move to the other node. Otherwise we have to fully license the whole cluster.
Now the question:How can I archive the move of all instances if one is moved? We are not speaking about a manual failover but about a case where one instance is automatically moved and the others have to follow.
My first idea was to build dependencies between each SQL Server Service but this doesn't work as i can't select other resources outside of the current role and in the properties of the role itself I can't define any dependencies.
I hope you are able to help me here.
Kind Regards,
Nedan
December 15, 2020 at 7:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 15, 2020 at 6:57 pm
To do that you need a script external to the cluster that monitors the state of the instances - and then performs a manual failover of all instances if it finds an instance that has been failed over.
Any script you come up with has to consider patching cycles - maintenance - temporary failover - etc...
Much easier to just license all nodes in a multi-instance cluster so you can utilize both servers to support active instances at the same time.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy