Chapter 7. Microsoft SQL Server Data Replication

THE KEY TOPICS IN THIS CHAPTER ARE

• Data replication and high availabiltiy

• The publisher, distributor, and subscriber metaphor

• Replication scenarios for high availability

• SQL Server replication types

• Planning for SQL Server data replication

• Building up replication

• Scripting replication

• Failing over to a warm standby subscriber

• HA scenario and replication