Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.