- 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.
- Excel高效辦公:會計與財務管理(AI版)
- Word/Excel 2010辦公應用從入門到精通
- 吸引力!創意PPT的設計與展現實用法則
- Minecraft創客制作:用樂高、3D打印、Arduino等創建Minecraft真實世界
- 和秋葉一起學WPS Office
- PowerPoint 2013從入門到精通
- AutoCAD2015中文版從入門到精通
- Excel人力資源管理必備的200個文件
- 游戲美術設計
- Windows 10從入門到精通
- Word Excel PPT PS 移動辦公5合1(全5冊)
- 新編Word/Excel/PPT 2003從入門到精通
- Unity 3D增強現實開發實戰
- PPT 2010設計技巧精粹(雙色精華版)
- Excel也可以很好玩(職場故事版)