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.
Unable to display preview. Download preview PDF.