Your SQL database with MSSQL-JDBC driver can have both disaster recovery and high availability by enabling the multi-subnet failover support in ePO 5.10.0.
Server must have ePO 5.10 Service Pack 1 Update 1 installed.
Check if your extensions are compatible MSSQL-JDBC driver (KB96549).
Launch epo server with administrator permissions.
Go to https://localhost:8443/core/config in a web browser to launch the Configure Database Settings page.
Note
8443 is the default port. It may vary based on your server core configuration.
In Database Driver, select MSSQL-JDBC from the drop-down list.
Specify/Check the database server port number.
Select the Multisubnet failover checkbox.
In Authentication, select SQL Server Authentication from the drop-down list.
Specify the username and password.
Click Test connection and verify the database connection with MSSQL JDBC driver.
(Recommended) Restart the ePO service.
For more information on Multi-subnet failover support, refer KB96625.