We are planning to setup failover clustering on windows server. We are currently having sql server 2016 standard edition.
I have few queries in mind.
Do we need to move on to enterprise edition/ sql 2019 before configuring clustering nodes, in case we want to move on future so is it better to move on before configuring clustering or its independent process ?
What happens when main node(server/instance) goes down?
How will the other node come up?
If we do maintenance/weekly updates(hardware/sql/software) on one node, how will it replicate/effect other
What happens if we restart one node? How will it sync with other node?
5. In case one node goes down, what about the transactions running on that node?
- Do we need to backup all data (full bckp,diff,trans log) separately or clustering takes itself in its functionality?
I need a bit of idea so that we decide the process of setting it up.