Export (0) Print
Expand All

Log Shipping Tables (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft