Skip to content

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

Latest commit

 

History

History
77 lines (51 loc) · 3.33 KB

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

File metadata and controls

77 lines (51 loc) · 3.33 KB
title Log Shipping Stored Procedures (Transact-SQL)
description Log Shipping stored procedures (Transact-SQL)
author markingmyname
ms.author maghan
ms.reviewer randolphwest
ms.date 06/23/2025
ms.service sql
ms.subservice system-objects
ms.topic reference
helpviewer_keywords
log shipping [SQL Server], stored procedures
system stored procedures [SQL Server], log shipping
dev_langs
TSQL

Log Shipping stored procedures (Transact-SQL)

[!INCLUDE SQL Server]

[!INCLUDE ssNoVersion] supports the following system stored procedures that are used to configure, modify, and monitor log shipping configurations.

:::row::: :::column::: sp_add_log_shipping_alert_job

    [sp_add_log_shipping_primary_database](sp-add-log-shipping-primary-database-transact-sql.md)

    [sp_add_log_shipping_primary_secondary](sp-add-log-shipping-primary-secondary-transact-sql.md)

    [sp_add_log_shipping_secondary_database](sp-add-log-shipping-secondary-database-transact-sql.md)

    [sp_add_log_shipping_secondary_primary](sp-add-log-shipping-secondary-primary-transact-sql.md)

    [sp_change_log_shipping_primary_database](sp-change-log-shipping-primary-database-transact-sql.md)

    [sp_change_log_shipping_secondary_database](sp-change-log-shipping-secondary-database-transact-sql.md)

    [sp_change_log_shipping_secondary_primary](sp-change-log-shipping-secondary-primary-transact-sql.md)

    [sp_cleanup_log_shipping_history](sp-cleanup-log-shipping-history-transact-sql.md)

    [sp_delete_log_shipping_alert_job](sp-delete-log-shipping-alert-job-transact-sql.md)

    [sp_delete_log_shipping_primary_database](sp-delete-log-shipping-primary-database-transact-sql.md)

    [sp_delete_log_shipping_primary_secondary](sp-delete-log-shipping-primary-secondary-transact-sql.md)
:::column-end:::
:::column:::
    [sp_delete_log_shipping_secondary_database](sp-delete-log-shipping-secondary-database-transact-sql.md)

    [sp_delete_log_shipping_secondary_primary](sp-delete-log-shipping-secondary-primary-transact-sql.md)

    [sp_help_log_shipping_alert_job](sp-help-log-shipping-alert-job-transact-sql.md)

    [sp_help_log_shipping_monitor](sp-help-log-shipping-monitor-transact-sql.md)

    [sp_help_log_shipping_monitor_primary](sp-help-log-shipping-monitor-primary-transact-sql.md)

    [sp_help_log_shipping_monitor_secondary](sp-help-log-shipping-monitor-secondary-transact-sql.md)

    [sp_help_log_shipping_primary_database](sp-help-log-shipping-primary-database-transact-sql.md)

    [sp_help_log_shipping_primary_secondary](sp-help-log-shipping-primary-secondary-transact-sql.md)

    [sp_help_log_shipping_secondary_database](sp-help-log-shipping-secondary-database-transact-sql.md)

    [sp_help_log_shipping_secondary_primary](sp-help-log-shipping-secondary-primary-transact-sql.md)

    [sp_refresh_log_shipping_monitor](sp-refresh-log-shipping-monitor-transact-sql.md)
:::column-end:::

:::row-end:::

Related content