SQL SERVER – Replication Keywords Explanation and Basic Terms

While discussing replication with Jr. DBAs at work, I realize some of them have not experienced replication feature of SQL SERVER. Following is quick reference of replication keywords 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 itself.

Distributor
The distributor is the intermediary between the publisher and subscriber. It receives published 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 publishing database are made at the subscription database at the same time.

MSDN : Replication

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQL SERVER – Replication Keywords Explanation and Basic Terms

  1. 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

    Like

  2. 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….

    Like

  3. 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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s