We created our Azure SQL MI in region US West, which does not support Zone redundancy. While we don’t require it now, we may require it in the future.  What options do we have now vs later to enable this? We have not gone live yet so we have the option to rebuild it entirely in a supported region, but if we decide not to do that, are there other options?  I’m thinking we would set up a new Azure SQL MI in a new region and use Availability Groups to replicate the data.

​We created our Azure SQL MI in region US West, which does not support Zone redundancy. While we don’t require it now, we may require it in the future.  What options do we have now vs later to enable this? We have not gone live yet so we have the option to rebuild it entirely in a supported region, but if we decide not to do that, are there other options?  I’m thinking we would set up a new Azure SQL MI in a new region and use Availability Groups to replicate the data.  Read More

​