MSdistributiondbs (Transact-SQL)
Applies to: SQL Server
The MSdistributiondbs table contains one row for each distribution database defined on the local Distributor. This table is stored in the msdb database.
Column name | Data type | Description |
---|---|---|
name | sysname | The name of the distribution database. |
min_distretention | int | The minimum retention period, in hours, before transactions are deleted. |
max_distretention | int | The maximum retention period, in hours, before transactions are deleted. |
history_retention | int | The number of hours to retain history. |
See Also
Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for