Distribution Database Properties, Database Tab (Creating New Database)
The following options are available on the Database tab of the Distribution Database Properties dialog box when creating a new distribution database.
Options
Database name
Specify the name of the new distribution database.
Folder for database file
Enter the path for the distribution database file.
(. . .)
Browse for the folder in which to store the distribution database.
Folder for log file
Enter the path for the log file for the distribution database.
(. . .)
Browse for the folder in which to store the log file for the 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 transactions 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 transactions 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
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 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.