Due to some requirements, restrictions and app incompatibility I am being forced into using SQL on VM in azure instead of Azure SQL and Managed Instance.
What is the best way to go about failover clustering on Azure VM's for SQL. 2016 or 2019 SQL Standard Licensing, Microsoft Server 2016 or 19. Need to be able to backup the databases/servers.
I tried backing up a non sql cluster using azure backup and a Storage Spaces Direct Cluster, the backups didn't work. So is my only option SQL Always on or use a 3rd party backup software and use S2D again?
I just need a direction and some options, I can figure out the configuration.