Chapter 19. Replication

IN THIS CHAPTER

• What’s New in Data Replication

• What Is Replication?

• The Publisher, Distributor, and Subscriber “Magazine” Metaphor

• Replication Scenarios

• Subscriptions

• Replication Agents

• Planning for SQL Server Data Replication

• SQL Server Replication Types

• Basing the Replication Design on User Requirements

• Setting Up Replication

• Scripting Replication

• Monitoring Replication

There is no such thing as a typical configuration or application anymore. Companies now have to support numerous hardware and software configurations in multitiered, distributed environments. These diverse configurations and applications (and users of the applications) come in all sizes and shapes. And, of course, you need a ...

Get Microsoft® SQL Server 2008 R2 Unleashed 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.

Start your free trial