This topic has not yet been rated - Rate this topic

Log Shipping Tables (Transact-SQL)

SQL Server 2008

Other Versions

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions