title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|
Log Shipping Tables (Transact-SQL) |
Log Shipping Tables (Transact-SQL) |
VanMSFT |
vanto |
08/09/2016 |
sql |
system-objects |
reference |
|
|
[!INCLUDE SQL Server]
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.