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.