Two main tables in a distribution database to facilitate replication

Somebody asked me this question: “What are the two main tables in a distribution database when you configure replication

The two main tables in a distribution database to facilitate replication are those that contain the information on where to start the replication from and to where this is to be sent to. Meaning one table to store source information and another to store destination information on the distribution database.

1. MSpublications or IHpublications ( for non-SQL Server publication )
2. MSsubscriptions or IHsubscriptions ( for subscription to a publication from a non-SQL Server Publisher )

This entry was posted in Replication, SQL Server, Tricks and tagged . Bookmark the permalink.

Leave a Reply