How to set the retention period for a distribution database (Enterprise Manager)

To set the retention period for a distribution database

1. Expand a server group; then expand the Distributor.
2. On the Tools menu, point to Replication, and then click Configure Publishing, Subscribers, and Distribution.
3. On the Distributor tab, select a distribution database, and then click Properties.
4. Under Transaction retention, enter the minimum and maximum retention periods.

See Also

Modifying Distributor and Publisher Properties