Log Shipping Stored Procedures (Transact-SQL)

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

Reference

System Stored Procedures (Transact-SQL)

Other Resources

Log Shipping

Help and Information

Getting SQL Server 2005 Assistance