Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Log Shipping Tables

Log Shipping Tables

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

Topic Description

log_shipping_monitor_alert (Transact-SQL)

Stores alert job IDs for log shipping.

log_shipping_monitor_error_detail (Transact-SQL)

Stores error detail for log shipping jobs.

log_shipping_monitor_history_detail (Transact-SQL)

Stores history details for log shipping jobs.

log_shipping_monitor_primary (Transact-SQL)

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

log_shipping_monitor_secondary (Transact-SQL)

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

log_shipping_primary_databases (Transact-SQL)

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

log_shipping_primary_secondaries (Transact-SQL)

Maps each primary database to its secondary databases. This

log_shipping_secondary (Transact-SQL)

Stores one record per secondary ID.

log_shipping_secondary_databases (Transact-SQL)

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

Community Additions

ADD
Show:
© 2015 Microsoft