Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Distribution Database Properties, Database Tab (Existing Database)

SQL Server 2000

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.

See Also

Publishers, Distributors, and Subscribers

Replication Properties

Transactional Replication

Show:
© 2015 Microsoft