Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Snapshot replication - How often does it sync
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yak Posting Veteran

84 Posts

Posted - 12/21/2012 :  15:41:39  Show Profile  Reply with Quote

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:

On the publication Wizard - the SnapShot Agent page:
I selected both options -
Create a Snapshot immediately AND
Schedule 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:


Distribution Agent Location
Run each agent at its subscriber (Pull Subscription)

Synchronization Schedule
Agent Location: Subscriber
Agent Schedule: Run Continuously

Initialize 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

Flowing Fount of Yak Knowledge

7174 Posts

Posted - 12/22/2012 :  09:32:34  Show Profile  Reply with Quote
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.
Go to Top of Page

Starting Member

3 Posts

Posted - 12/27/2012 :  03:55:56  Show Profile  Reply with Quote
I am so glad this internet thing works and your article really helped me. Might take you up on that home advice you.
[url=]Doudoune Moncler[/url]
[url=]Moncler Manteau Femme[/url]
[url=]Tiffany & Co Outlet[/url]
[url=]Karen Millen Dress[/url]
[url=]Belstaff Jackets[/url]

xingchent xingchent
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000