Log Shipping stored procedures (Transact-SQL)

Applies to: SQL Server

SQL Server supports 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

Related content

• About log shipping (SQL Server)
• System stored procedures (Transact-SQL)