| title | Log Shipping Tables (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 08/09/2016 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | f8910aae-2013-4645-880c-134577cbcbe0 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
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.