Log Shipping Stored Procedures (Transact-SQL)

Applies to: SQL Server (all supported versions)

Microsoft SQL Server and later versions support the following system stored procedures that are used to configure, modify, and monitor log shipping configurations.

sp_add_log_shipping_alert_job

sp_add_log_shipping_primary_database

sp_add_log_shipping_primary_secondary

sp_add_log_shipping_secondary_database

sp_add_log_shipping_secondary_primary

sp_change_log_shipping_primary_database

sp_change_log_shipping_secondary_database

sp_change_log_shipping_secondary_primary

sp_cleanup_log_shipping_history

sp_delete_log_shipping_alert_job

sp_delete_log_shipping_primary_database

sp_delete_log_shipping_primary_secondary

sp_delete_log_shipping_secondary_database

sp_delete_log_shipping_secondary_primary

sp_help_log_shipping_alert_job

sp_help_log_shipping_monitor

sp_help_log_shipping_monitor_primary

sp_help_log_shipping_monitor_secondary

sp_help_log_shipping_primary_database

sp_help_log_shipping_primary_secondary

sp_help_log_shipping_secondary_database

sp_help_log_shipping_secondary_primary

sp_refresh_log_shipping_monitor

See Also

About Log Shipping (SQL Server)
System Stored Procedures (Transact-SQL)