My system has a number of users accessing a RemoteApp collection. The primary application they use is talking to an SQL database. Having a reliable connection to the database is critical in providing value to the users.
The SQL database resides on a Windows Server 2012 VM in Azure.
The VM is in an availability set with a VM taken from an image which is similar to my primary Windows Server VM. I understand that this will not protect my users from downtime caused by Microsoft?
Any guidance on overcoming this problem would be appreciated.
The two options I have thought of so far would be:
Put my VM in an availability set with a constantly updated clone of itself (another instance of that machine?). I'm not sure this is possible or how I would implement it. Would I need to use Azure Powershell?
Build an Azure SQL database and use that so the VM is not relied upon. Could do this through the portal or again through Azure Powershell.
Thanks for your time.