Reply To: QUICK QUESTION re. distributor database

#8821
Mark
Keymaster

1. The distributor database is a core part of SQL Server Replication, and so is the concept of articles. We need articles to enable what we call supplemental logging so that on the destination side the SQL can be replayed using primary key columns. Given the two concepts are tied together I would strongly recommend against deleting the distributor database after articles were created.

Note that HVR 5 by default uses CDC tables to track changes and if you only use CDC tables to track changes then a distributor database is not required and does not need to be created.

2. I don’t understand your question. If you refer to the distributor database then please no that in the context of HVR this database is simply a side-effect of the use of articles and there is nothing in the database that determines the routing of the data. HVR takes care of this.

Hope this clarifies.

Test drive
Contact us