Log Shipping Tables
The document is archived and information here might be outdated

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.

Show:
© 2016 Microsoft