Log Shipping Tables (Transact-SQL)

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

In This Section

• 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.