官术网_书友最值得收藏!

Understanding Transactional Replication

In this section, we'll look at how transactional replication works. The following diagram describes how transactional replication works:

Figure 2.1: Transactional replication example

This diagram shows the AdventureWorks database being replicated using transactional replication. Once transactional replication is configured, the snapshot agent, log reader agent, and distribution agent are created as part of the replication. The agents then work together, as described here, to replicate the transactions.

The snapshot agent is used once to initialize the subscriber database schema with that of the publisher. This isn't shown in the diagram, however, it's the first thing that happens when the transactional replication starts.

The subscriber database can be initialized using the publisher database backup, which is covered later in this lesson.

Once initialized, the transactions are replicated as follows:

  • Steps 1 and 2: The log reader agent continuously scans for committed transactions in the publisher database transaction log and inserts the transactions to be replicated into the distribution database.

    The log reader agent is at the distributor or at the publisher if the publisher acts as its own distributor.

  • Steps 3 and 4: The distribution agent reads the transactions from the distribution database and applies them to the subscriber. The distribution agent is at the distributor if it's a push subscription and at the subscriber if it's a pull subscription.
主站蜘蛛池模板: 句容市| 横山县| 崇州市| 陕西省| 黄平县| 康定县| 赤壁市| 罗江县| 綦江县| 喀喇沁旗| 八宿县| 贵州省| 固始县| 沁源县| 沐川县| 娄烦县| 大港区| 纳雍县| 石台县| 綦江县| 南澳县| 平塘县| 沙河市| 河源市| 嘉峪关市| 和硕县| 梁山县| 永平县| 隆子县| 松潘县| 八宿县| 乌海市| 伊春市| 土默特右旗| 金坛市| 海淀区| 子洲县| 枝江市| 监利县| 志丹县| 宝兴县|