As I understand it if you are using mirroring on SQL server and have failover setup you can adjust the connection strings of your applications that use it so they know the name of the other server ...

Direct Point-to-Point Mirroring: Real-time replication from on-premise SQL Server to Microsoft Fabric via Open Mirroring for fast and seamless unified analytics. Azure Marketplace Availability: Striim ...

Without using any special hardware, it allows you to duplicate (real time mirroring) a production database on another SQL Server at a different location.