0 out of 1 rated this helpful - Rate this topic

Log Shipping Tables

SQL Server 2005

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? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions