Distribution Database Properties, Database Tab (Existing Database)
The following options are available on the Database tab of the Distribution Database Properties dialog box when viewing the properties of an existing distribution database.
Options
Database name
View the name of the distribution database.
These Publishers use this database
View the list of Publishers currently using this distribution database.
Transaction Retention
Reduce the amount of disk space used on the Distributor by minimizing the amount of time for log history and transaction retention.
Store transactions at least
Set the minimum length of time the transaction records are stored in the distribution database. If the unit of time is hours, the minimum value is 0 and the maximum value is 32767. If the unit of time is days, the minimum value is 0 and the maximum value is 1365. The minimum value must be less than the maximum value for storing records.
But not more than
Set the maximum length of time the transaction records are stored in the distribution database. If the unit of time is hours, the minimum value is 0 and the maximum value is 32767. If the unit of time is days, the minimum value is 0 and the maximum value is 1365. The maximum value cannot be less than or equal to the minimum value.
Hours
Use hours as the unit of time for storing transaction records.
Days
Use days as the unit of time for storing transaction records.
History Retention
You can reduce the amount of disk space used on the Distributor by minimizing the amount of time for log history and transaction retention.
Store replication performance history at least
Set the minimum length of time the replication performance history is stored in the distribution database. If the unit of time is hours, the minimum value is 0 and the maximum value is 32767. If the unit of time is days, the minimum value is 0 and the maximum value is 1365. The minimum value must be less than the maximum value for storing performance history.
Hours
Use hours as the unit of time for storing replication performance history.
Days
Use days as the unit of time for storing replication performance history.