MSdistributiondbs (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)