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

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:
© 2015 Microsoft