What The Different Components In Replication And What Is Their Use?

1.	What The Different Components In Replication And What Is Their Use?
Answer» The 3 main COMPONENTS in REPLICATION are Publisher, Distributor and Subscriber. Publisher is the data source of a publication. Distributor is responsible for distributing the DATABASE objects to one or more destinations. Subscriber is the destination where the publishers data is COPIED / replicated. The 3 main components in Replication are Publisher, Distributor and Subscriber. Publisher is the data source of a publication. Distributor is responsible for distributing the database objects to one or more destinations. Subscriber is the destination where the publishers data is copied / replicated.

Answer»

The 3 main COMPONENTS in REPLICATION are Publisher, Distributor and Subscriber. Publisher is the data source of a publication. Distributor is responsible for distributing the DATABASE objects to one or more destinations. Subscriber is the destination where the publishers data is COPIED / replicated.

The 3 main components in Replication are Publisher, Distributor and Subscriber. Publisher is the data source of a publication. Distributor is responsible for distributing the database objects to one or more destinations. Subscriber is the destination where the publishers data is copied / replicated.

Discussion

No Comment Found

Related InterviewSolutions

What Is The Difference Between The 2 Operating Modes Of Database Mirroring?
What Are The Operating Modes In Which Database Mirroring Runs?
Does Transparent Data Encryption Provide Encryption When Transmitting Data Across Network?
What Is Transparent Data Encryption?
What Are The Different Types Of Upgrades That Can Be Performed In Sql Server?
What Are The Different Types Of Database Compression Introduced In Sql Server 2008?
Which Autogrowth Database Setting Is Good?
What Is The Difference Between Dropping A Database And Taking A Database Offline?
When Setting Replication, Is It Possible To Have A Publisher As 64 Bit Sql Server And Distributor Or Subscribers As A 32 Bit Sql Server.
When Setting Replication, Can You Have Distributor On Sql Server 2005, Publisher On Sql Server 2008?