TechNet
Export (0) Print
Expand All

Log Shipping Tables (Transact-SQL)

 

Updated: August 9, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The following topics 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.

Community Additions

ADD
Show:
© 2016 Microsoft