When setting up replication in SQL Server, the first thing to set up is Distributor.
The Distributor is a SQL server instance that contains the distribution database, which stores metadata and history data for all types of replication and transactions for transactional replication.
The Distributor is a SQL server instance that contains the distribution database, which stores metadata and history data for all types of replication and transactions for transactional replication.
Properties of Distributor
- Each Publisher can be assigned to a single Distributor instance only
- Multiple publishers can share a single Distributor
To Configure Distributor:
- Connect to the SQL Server instance using Management Studio which you want to make as Distributor