I currently have a 2016 SQL standalone server. Currently we back the entire server up overnight, but this still leaves us vulnerable to major down time should there be a server outage. Currently we host a CRM server and live client data bases on this server.
I'm looking to see if it is possible and fairly painless to convert this into a fail over cluster and push up a secondary server to act as the fall over .. Maybe not the correct terminology, but my understanding is that should the main server (svr1) be switched off for instance, then svr2 would in effect be the live server. I welcome any advice on if this is the norm, or any alternatives.
I am by no means an expert in SQL and welcome all and any suggestions