February 1, 2007 at 6:50 am
I have transactional replication setup on SQL Server 2000 SP3a.
I've created a pull subscription selecting "Yes, initialize the schema and data" and then started the snapshot agent manually, and this completes successfully, and the log reader runs successfully, as does the pull subscription agent.
The question I have is, can I stop the pull subscription agent, and will the transactions be queued until I start the pull subscription agent again, at which point does the Log Reader agent apply those transactions to the subscriber database?
Thanks in advance.
www.sqlAssociates.co.uk
February 1, 2007 at 8:50 pm
The Log Reader agent does not apply transactions to the subscriber database. Its role is to extract transactions from the transaction log of the published database and store them in the distribution database.
The distribution agent is responsible for reading relevant transactions from the distribution database and appying them to the subsciber database. A distribution agent can be either push or pull (pull subscription agent).
Both of these agents operate independently of each other. You can stop either of them without having a negative impact on the other. When an agent starts up again, it simply starts from where it finished last time.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply