SQL Administrator Question: Download Questions PDF
Tell us what the different components of Replication and what is their use?
Answer:
The 3 main components in Replication are Publisher, Distributor, and Subscriber. The publisher is the data source of a publication. The distributor is responsible for distributing the database objects to one or more destinations. The subscriber is the destination where the publisher's data is copied/replicated.
Download SQL Administrator Interview Questions And Answers
PDF