SQL Server Failover Cluster and Licensing

  • 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 me2020-12-14 07_10_59-SQL Server 2019 Licensing guide.pdf - Adobe Acrobat Reader DC

    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

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • 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