Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




SQL Server interview questions: - Define publisher, distributor and subscriber in “Replication”?

This is the most expected asked SQL Server interview questions during the interview by the interviewer.

Publisher is the one who owns the database and is the main source for data. Publisher identifies what data should be distributed across.

Distributor is a bridge between publisher and subscriber. Distributor gathers all the published data and holds it until it sends it across to all subscriber. So as it is a bridge who sits in between publisher and subscriber, it supports multiple publisher and subscriber concept.

Subscriber is the end source or the final destination to which data has to be transmitted.

Figure: - Publisher, Distributor and Subscriber in action

View video on Query Plan, Logical/Physical operators in SQL Server as follows: -

Click for more SQL Server interview questions

Regards,

Visit for more author’s blog on SQL Server interview questions

Share this article   |    Print    |    Article read by 5759 times
Author:
Shivprasad koirala Koirala
I am a Microsoft MVP for ASP/ASP.NET and currently a CEO of a small E-learning company in India. We are very much active in making training videos , writing books and corporate trainings. Do visit my site http://www.questpond.com for .NET, C# , design pattern , WCF , Silverlight , LINQ , ASP.NET , ADO.NET , Sharepoint , UML , SQL Server training and Interview questions and answers
Related Articles: No related article
Related Interview Questions: No related interview question