Replication Concepts
Before jumping into configuring and using replication, let’s look at a few replication concepts. First we’ll look at the "publish and subscribe" metaphor and the three types of replication, then we’ll examine replication data and data propagation, and last we’ll discuss replication agents.
Replication Components
SQL Server 2005 replication is based on the "publish and subscribe" metaphor first used to implement replication in SQL Server 6.0 and enhanced in SQL Server 7.0 and SQL Server 2000. This metaphor is built on the concepts of publishers, subscribers, and distributors. A publisher is a database that makes data available for replication. A subscriber is a server that receives replicated data and stores the replicated database. ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.
