Microsoft SQL Server Data Replication Overview
Yes, you can use data replication as a high availability solution! It depends on your HA requirements, though (as usual). Originally Microsoft's SQL Server implementation of data replication was created to off-load processing from a very busy server such as an online transaction processing (OLTP) application. Data replication enabled big chunks of processing (like that of reporting) to be isolated “away from” the primary OLTP without having to sacrifice performance. It also was well suited to support naturally distributed data that has very distinct users (such as a geographically oriented order entry system). As data replication became more stable and reliable (post MS SQL Server 6.5's implementation), ...
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
