Skip to content

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 description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords dev_langs
Log Shipping stored procedures (Transact-SQL)
Log Shipping stored procedures (Transact-SQL)
markingmyname
maghan
randolphwest
08/21/2024
sql
system-objects
reference
log shipping [SQL Server], stored procedures
system stored procedures [SQL Server], log shipping
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