Forum Discussion
Test failover for Azure SQL database
Hi I want to use a failover group to protect an Azure SQL server, for DR purposes, but I'm unsure how to perform a test failover. Can I use a recovery plan perform a test failover, keeping th...
To perform a test failover, go to the Azure portal, select your SQL server, and navigate to the Failover Groups section. Choose the failover group and select "Test Failover." This switches to the secondary server for testing without interrupting the primary. After the test, you can fail back to the original primary server.
Hope that helps. Best regards :)