- Professional SQL Server High Availability and Disaster Recovery
- Ahmad Osama
- 222字
- 2021-06-11 13:30:35
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.
- 中文版Rhino 5.0實(shí)用教程
- 新編Excel 2010從入門到精通
- 新手易學(xué):電腦辦公
- Unity 2018 AR與VR開(kāi)發(fā)快速上手
- Word/Excel/PPT實(shí)戰(zhàn)技術(shù)大全
- Excel 2013應(yīng)用技巧實(shí)例大全
- 普通WPS Word規(guī)范排版公文格式
- PPT制作事半功倍
- Excel高效辦公:VBA范例應(yīng)用(修訂版)
- LoadRunner性能測(cè)試巧匠訓(xùn)練營(yíng)
- Excel 2016中文版完全自學(xué)手冊(cè)
- PowerPoint 2010辦公專家從入門到精通(精編版)
- Excel高效辦公:公司管理(修訂版)
- AI智能辦公實(shí)戰(zhàn)108招:ChatGPT+Word+PowerPoint+WPS
- Word/Excel/PPT辦公應(yīng)用從入門到精通