Describe In Brief Working Of Replication?

1.	Describe In Brief Working Of Replication?
Answer» At first data and object is synchronized between PUBLISHER and subscribers. The snapshot is created on the publisher and transmitted to subscribers. All the subsequent CHANGES on the publisher are stored in distribution database. SUBSCRIBER receives the data either using push or PULL mechanism as configured from distribution database. At first data and object is synchronized between publisher and subscribers. The snapshot is created on the publisher and transmitted to subscribers. All the subsequent changes on the publisher are stored in distribution database. Subscriber receives the data either using push or pull mechanism as configured from distribution database.

Answer»

At first data and object is synchronized between PUBLISHER and subscribers. The snapshot is created on the publisher and transmitted to subscribers. All the subsequent CHANGES on the publisher are stored in distribution database. SUBSCRIBER receives the data either using push or PULL mechanism as configured from distribution database.

At first data and object is synchronized between publisher and subscribers. The snapshot is created on the publisher and transmitted to subscribers. All the subsequent changes on the publisher are stored in distribution database. Subscriber receives the data either using push or pull mechanism as configured from distribution database.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Agents Used For Merge Replication?
What Are The Agents Used For Transactional Replication?
What Are The Uses Of Replication?
What Is A Transaction Replication?
What Is Merge Replication?
What Is Snapshot Replication?
What Are Different Models/types Of Replication?
What Is “push” And “pull” Subscription?
What Are Publisher, Distributor And Subscriber In “replication”?
Can You Tell Me Some Of The Common Replication Dmv's And Their Use?