TechNet
Expand All
This documentation is archived and is not being maintained.

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