log-shipping-stored-procedures-transact-sql.md

title	Log Shipping Stored Procedures (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	log shipping [SQL Server], stored procedures system stored procedures [SQL Server], log shipping
ms.assetid	39554188-20fe-42ec-a53f-35e1dc98c274
author	stevestein
ms.author	sstein

Log Shipping Stored Procedures (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx-md]

[!INCLUDEmsCoName] [!INCLUDEssNoVersion] 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)