Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dolphin123
Yak Posting Veteran
84 Posts |
 Posted - 2012-12-21 : 15:41:39
|
Hi,I am new to setting up replication. I setup a snapshot replication with selected tables. I am not how the replication is kicked off and how both database are kept in sync:This is what I selected when I created the Publisher:quote:
On the publication Wizard - the SnapShot Agent page:I selected both options - Create a Snapshot immediately ANDSchedule the snapshot agent: every 2 hours.
What does creation a snapshot immediately option mean? Who can it synch before a subscriber is created?What does the "Schedule the snapshot agent every 2 hours" do? Will it look for all the subscribers and sync? If it can't find a subscriber, it will not error out, but just stop and check again in 2 hours?in Subscriber:When i was creating the subscriber, I selected the following:quote:
Distribution Agent Location Run each agent at its subscriber (Pull Subscription)Synchronization Schedule Agent Location: Subscriber Agent Schedule: Run ContinuouslyInitialize Subscription: Initialize when: Immediately
What is the difference between, initialize and synchronize? Initialize just checks if the tables that are suppose to be replicated exist in the subscriber? And the sync is copying the data over to the subscriber?When the syncing happens, does it copy only the additional data to the subscriber or does it empty the tables in the subscriber and load the whole data again?Since I selected "Run each agent at its subscriber (Pull Subscription)", Shouldn't the sync be initiatied from the subscriber? why did I mention to run this every 2 hours on the publisher?Also in subscriber, I selected Agent Location: Subscriber, Agent Schedule: Run Continuously; What does this Run continuously mean? will it look at the publisher for data changes continuously and initiate a sync?I know.. I asked a lot of questions. I would appreciate your answers a lot. Thanks a lot.- D |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-22 : 09:32:34
|
| Well you can learn details about Replication in Books online it has very good informations about different types of Replications.Snapshot Replication basically takes snapshot of your db and replicates to subscriber based on what schedule you provide.There are many internals like publisher (from where you are replicating),distributer and subcriber(destination for replication)which involves. There are several replication agent which participate when you are doing replication like snapshot agent,log reader agent,distribution agent. |
 |
|
|
xingchent
Starting Member
3 Posts |
Posted - 2012-12-27 : 03:55:56
|
| I am so glad this internet thing works and your article really helped me. Might take you up on that home advice you.[url=http://www.doudounezmoncler.com]Doudoune Moncler[/url][url=http://www.doudounezmoncler.com/moncler-manteau-femme-c-3.html]Moncler Manteau Femme[/url][url=http://www.tiffanysoutletmall.com]Tiffany & Co Outlet[/url][url=http://www.karenvmillendress.com]Karen Millen Dress[/url][url=http://www.belstaffoutletonline.co.uk]Belstaff Jackets[/url]xingchent xingchent |
|
|
|
|
|
|
|
|
Snapshot replication - How often does it sync