Export (0) Print
Expand All

Log Shipping Tables (Transact-SQL)

The topics in this section describe the system tables that store the information used by log-shipping operations.

log_shipping_monitor_alert

Stores alert job IDs for log shipping.

log_shipping_monitor_error_detail

Stores error detail for log shipping jobs.

log_shipping_monitor_history_detail

Stores history details for log shipping jobs.

log_shipping_monitor_primary

Stores one monitor record per primary database in each log shipping configuration.

log_shipping_monitor_secondary

Stores one monitor record per secondary database in a log shipping configuration.

log_shipping_primary_databases

Stores one record for the primary database in a log shipping configuration.

log_shipping_primary_secondaries

Maps each primary database to its secondary databases.

log_shipping_secondary

Stores one record per secondary ID.

log_shipping_secondary_databases

Stores one record per secondary database in a log shipping configuration.

Community Additions

ADD
Show:
© 2014 Microsoft