While discussing replication with Jr. DBAs at work, I realize some of them have not experienced replication feature of SQL SERVER. Following is a quick reference I created for easy conversation.
Publisher
The publisher is the source database where replication begins. It makes data available for replication.
Subscriber
The subscriber is the destination database where replication ends. It either receives a snapshot of all the published data or applies transactions that have been replicated to it.
Distributor
The distributor is the intermediary between the publisher and subscriber. It receives publishing transactions or snapshots and then stores and forwards these publications to the subscribers.
Publication
The publication is the storage container for different articles. A subscriber can subscribe to an individual article or an entire publication.
Article
An article is the data, transactions, or stored procedures that are stored within a publication. This is the actual information that is going to be replicated.
Two-phase commit
Two-phase commit is a form of replication in which modifications made to the publications database are made in the subscription database at the same time.
Let me know what you think about this short and quick article. If you like this format, I will publish more such articles on this blog in the future.  The beauty of it is that it enables many users to work with their own local copy of a database but have the database updated as if they were working on a single, centralized database.
Reference: Pinal Dave (https://blog.sqlauthority.com)
8 Comments. Leave new
HI Pinal,
Could you please post an article dedicated to replication..you can say in-depth article.
thanks,
nitin
i would like that too..!
HI Pinal,
I would like to know more about the replication,Now i had set up a merge replication of one publisher and two subscribers at remote using vpn and its working fine and the log file size is growing like a blast… now i need a help that how to remove a un wanted article(Table) from the replication with out stoping the replication.b’cos the work is going 24 hours so that when we stop the replication the snap shot have to start . so that the data lose will be there … please do help me. plz do reply to my mail
Hi! Pinal,
I need your help to know the difference between Replication and Mirroring.
Thanks
Hi everybody.. who all asked regarding REPLICATION…
REPLICATION-
example:- If two servers are in two different zones,,say.. one server is in India and the other one is in USA… if the users all over the world updates their record, data should get updated in both the servers in India as well as in USA
in a timely fashion….
hence replications are enforced….
hello,
————————————————————-
“Mannoj Kumar
Hi everybody.. who all asked regarding REPLICATION…
REPLICATION-
example:- If two servers are in two different zones,,say.. one server is in India and the other one is in USA… if the users all over the world updates their record, data should get updated in both the servers in India as well as in USA
in a timely fashion….
hence replications are enforced….
————————————————————————–
how the replication is done in the above case,if the only available option.Please explain in detail. i’m having Sql server 2005 express edition.
Thanks
Very Nice!
Hi Pinal…
Please explain the overall concept of replication in detail..
Thanks