Home Topics HVR Real-time Replicator Knowledge Base Is the SQL Server distribution database required by HVR for log-based Capture?
Problem Summary: Is the SQL Server distribution database required by HVR for log-based Capture?
A distribution database is created by user with sysadmin privileges for SQL Server instance only if articles are used.
If a log based capture is setup from SQL Server as a source then there are two ways in which capture action can be configured to enable Supplemental Logging in SQL server.
If the first one is used, i.e. CDC tables for supplemental logging then, you need to have the source database enabled for replication and the distribution database is no longer needed.
If the second one is used i.e. articles, SQL Server’s own replication components are used for enabling supplemental logging then distribution database is required.
© 2020 HVR
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.