This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Greetings.
I'm trying to set up regional disaster recovery solution for several Azure MS SQL databases that are assigned to Elastic Pool. I've prepared pilot solution with Auto-Failover groups according the article
All works well for me. After execution manual failover my databases are accessible by Primary listener.
But I need to check how real auto-failover is executed? How can I emulate real regional disaster?
I found some articles about such emulation for other database servers, like MySQL.
But could not find any information about MS SQL servers.
Please could You give some advice?
Thank You
If your question indeed is about Azure SQL, you should use the appropriate azure- tag. sql.server-general would be an appropriate tag, if you want to do this on-prem.
You can use Azure Chaos Studio to run high availability (HA) drills to test database resilience against region outages. It can be used to test Azure SQL and SQL Server VMs. Here you can know more about posible targets.
Thank You.
Will take a look on this tool.
Greetings.
Briefly looked at Azure Chaos Studio. It is not obvious for me that it can work with SQL Servers.
I've read the possible targets and fault library sections and did not find any mentions about SQL at all.
Of course, there are some specific faults for CosmosDB, Redis Cache or KeyVault and these type of objects can be chosen as targets. But I even can not see any SQL based objects in the list of possible targets. Although I have a lot of such objects in the subscription where Chaos resource provider is enabled.
Probably this experiment should include more complex implementation.
Do You have some experience to make unavailable SQL Server in a region?
As mentioned in the doc - I do not see any SQL objects because they are not in the list of supported resource types.
My region is East US and it is supported region for Azure Chaos Studio.
You are correct DocumentDB and Cosmos DB only. And VMs
Here you will find more ways to simulate an outage, specifically for Azure SQL Database
Thank You.
I've already read this article.
As I understand the aim of this testing is to discover possibility for application to keep life after disaster.
I mean:
But my aim is testing real Auto failover for the whole SQL Server in case of regional disaster without any manual interaction to recover.
It is not related with application but only with Azure objects.
Maybe when Azure Chaos is getting closer to public realease (not preview) we will have what you need as it will probably cover more targets. For now, this article is the closest we can get to a real simulation.