Chapter 27. Replication

by Laura Jones

IN THIS CHAPTER

  • Replication Overview and Terminology

  • Creating and Assigning the Distribution Database

  • Configuring Replication Distribution Options

  • Deleting a Distribution Database

  • Configuring Replication Publishing

  • Enabling Replication Subscribers

  • Using the Disabling Publishing and Distribution Wizard

  • Adding NonSQL Server (Heterogeneous) Subscribers

  • Upgrading SQL Server Replication

  • Replication FAQ

Data replication is a powerful feature of SQL Server. SQL Server 7.0 provided many improvements from previous versions, and SQL Server 2000 builds on those features and adds more to increase the reliability, ease of use, and management of replication.

NOTE

I throw in the fact that it ships with the standard product because ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.