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.
Oops! Looks like you're using an outdated browser...
It appears you are still using Internet Explorer. Support for IE has been discontinued by Microsoft, and many features of our site may not display or work properly.
Please upgrade (it's free!) to Edge, Chrome, Safari, or any modern browser for the best user experience.