October 23, 2009 at 3:56 am
Hi all - I am new to replication and had a question about the log reader agent for transactional replication. If I use transactional replication on demand i.e. not constabtly running the job, and was to perform an update to my publisher, then perform a transaction log backup then run the replication, would my update appear in the subscriber?
My testing has indicated that it does appear in the subscriber, but this seems to be against what I have been reading as the log agent reader reads from the log itself.
All input welcome.
Thanks
October 23, 2009 at 5:56 am
As soon as you mark an article for replication, all transactions for that article is flagged as for replication. So even if you do a transaction log back up, the transaction in question that is connected to the article does not get cleared. It will be removed from the transaction log only after the log reader agent has picked it up. That is how it is designed.
-Roy
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply