In the previous chapter, I introduced replication as a method of distributing data. I described what asynchronous replication is and outlined the replication types available in SQL Server. We are now ready to look at the details of replication. In this chapter, I will explain the Publisher-Subscriber model that is used to represent the several components involved in replication: the Distributor, Publisher, Subscriber, publications, articles, subscriptions, and agents. In addition, you will also learn how different agents are used in transferring the data.
KeywordsPublisher Server Replication Agent Distributor Server Subscriber Server Distribution Agent
Unable to display preview. Download preview PDF.