Guidelines for primary and alternate servers
- Last Updated: October 29, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Microsoft SQL Server 8.0
- Documentation
SQL Server databases provide advanced database replication technologies through the AlwaysOn feature. The failover functionality provided by the drivers does not require AlwaysOn, but can work with this technology to provide comprehensive failover protection. To ensure that failover works correctly, alternate servers should mirror data on the primary server or be part of a configuration where multiple database nodes share the same physical data.