September 28, 2009 at 12:44 pm
I'm a beginner at replication, and trying to look at an existing replication job. From server A to server B. Looks like its just one-way replication. with a A being the publisher/Distributor, and B, being the subscriber. Is there a way to tell how often replication kicksoff? a scheduler of some type? Need to answer the question "is replication occuring every 5, 10, or 15 minutes?" or is it constant, every time a change occurs on A, is B automatically updated. Basically a continuous update/replication?
September 28, 2009 at 3:25 pm
It depends.
It depends on the type of replication. If it is Snapshot replication, it will be scheduled to run at a certain interval. But if it is Transactional replication and set with immediate, then it will update as soon as a data is changed. (Of course there might be a small lag)
-Roy
September 28, 2009 at 3:31 pm
How can I tell whether its snapshot or transactional? I'm thinking its just transactional, but I'll double check.
September 28, 2009 at 3:32 pm
Ok, its transactional.
September 28, 2009 at 3:33 pm
Where do I check to see if the transactional rep is set to immediate?
September 29, 2009 at 7:05 am
If you script the Publication, check what is the value for @repl_freq. If it is continuous, then it updates the subscriber immediately.
-Roy
September 29, 2009 at 8:02 am
Awesome! Thank you very much. Really appreciate your help. I owe you a 6 pack. 🙂
September 29, 2009 at 1:19 pm
Glad I could help... Send out the Six pack by post...;-)
-Roy
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply