TheBugSlayer
Programmer
I have a transactional replication that's working just fine.
But one thing's got me confused:
When I checked the tables at the Suscriber I noticed they had today's date as date created; when I look at the messages in the Distribution Agent I see something like X row(s) copied, Total: Y; the values keep changing. I set it so that the changes are propagated continuously for a minimal latency. My understanding is that the snapshot is applied only once in this type of replication, and what happens next is that the Log Reader marks records for distribution in the distribution database, those changes are then applied by the Distribution Agent. It seems to me the tables are being recreated each time...can someone explain this whole process to me?
The other thing is that the number of rows in the subscriber database is not the same (less) as in the pulisher's, why is that so?
Any help is greatly appreciated.
But one thing's got me confused:
When I checked the tables at the Suscriber I noticed they had today's date as date created; when I look at the messages in the Distribution Agent I see something like X row(s) copied, Total: Y; the values keep changing. I set it so that the changes are propagated continuously for a minimal latency. My understanding is that the snapshot is applied only once in this type of replication, and what happens next is that the Log Reader marks records for distribution in the distribution database, those changes are then applied by the Distribution Agent. It seems to me the tables are being recreated each time...can someone explain this whole process to me?
The other thing is that the number of rows in the subscriber database is not the same (less) as in the pulisher's, why is that so?
Any help is greatly appreciated.