Log Shipping Tables

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

In This Section

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.