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_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_secondary_database
sp_delete_log_shipping_secondary_primary
sp_help_log_shipping_alert_job
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
Related content
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for