Log Shipping Stored Procedures (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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_delete_log_shipping_secondary_database
sp_add_log_shipping_primary_database sp_delete_log_shipping_secondary_primary
sp_add_log_shipping_primary_secondary sp_help_log_shipping_alert_job
sp_add_log_shipping_secondary_database sp_help_log_shipping_monitor
sp_add_log_shipping_secondary_primary sp_help_log_shipping_monitor_primary
sp_change_log_shipping_primary_database sp_help_log_shipping_monitor_secondary
sp_change_log_shipping_secondary_database sp_help_log_shipping_primary_database
sp_change_log_shipping_secondary_primary sp_help_log_shipping_primary_secondary
sp_cleanup_log_shipping_history sp_help_log_shipping_secondary_database
sp_delete_log_shipping_alert_job sp_help_log_shipping_secondary_primary
sp_delete_log_shipping_primary_database sp_refresh_log_shipping_monitor
sp_delete_log_shipping_primary_secondary

See Also

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