Forum Discussion

alexp01482's avatar
alexp01482
Copper Contributor
Mar 10, 2025

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 the primary node up and running for production, whilst the secondary is available for DR testing?

Cheers

Alex

azure
azure sql
Azure SQL DB
failover group
hadr

1 Reply

Sort By
  • MoritzG's avatar
    MoritzG
    Brass Contributor
    Mar 13, 2025

    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 :)

Resources