This topic has not yet been rated - Rate this topic

Log Shipping Stored Procedures (Transact-SQL)

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005
SQL Server 2012

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

Reference

System Stored Procedures (Transact-SQL)

Other Resources

Log Shipping Administration

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

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