Skip to content

sp-delete-log-shipping-primary-database-transact-sql.md

Latest commit

 

History

History
82 lines (60 loc) · 3.2 KB

sp-delete-log-shipping-primary-database-transact-sql.md

File metadata and controls

82 lines (60 loc) · 3.2 KB
title sp_delete_log_shipping_primary_database (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 06/10/2016
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
sp_delete_log_shipping_primary_database
sp_delete_log_shipping_primary_database_TSQL
dev_langs
TSQL
helpviewer_keywords
sp_delete_log_shipping_primary_database
ms.assetid cb1d5d00-2805-4d47-bd04-545232067345
caps.latest.revision 22
author JennieHubbard
ms.author jhubbard
manager jhubbard

sp_delete_log_shipping_primary_database (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]

This stored procedure removes log shipping of primary database including backup job as well as local and remote history. Only use this stored procedure after you have removed the secondary databases using sp_delete_log_shipping_primary_secondary.

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_delete_log_shipping_primary_database  
[ @database = ] 'database'

Arguments

[ @database = ] 'database'
Is the name of the log shipping primary database. database is sysname, with no default, and cannot be NULL.

Return Code Values

0 (success) or 1 (failure)

Result Sets

None.

Remarks

sp_delete_log_shipping_primary_database must be run from the master database on the primary server. This stored procedure does the following:

  1. Deletes the backup job for the specified primary database.

  2. Removes the local monitor record in log_shipping_monitor_primary on the primary server.

  3. Removes corresponding entries in log_shipping_monitor_history_detail and log_shipping_monitor_error_detail.

  4. If the monitor server is different from the primary server, removes the monitor record in log_shipping_monitor_primary on the monitor server.

  5. Removes corresponding entries in log_shipping_monitor_history_detail and log_shipping_monitor_error_detail on the monitor server.

  6. Removes the entry in log_shipping_primary_databases for this primary database.

  7. Calls sp_delete_log_shipping_alert_job on the monitor server.

Permissions

Only members of the sysadmin fixed server role can run this procedure.

Examples

This example illustrates using sp_delete_log_shipping_primary_database to delete the primary database AdventureWorks2012.

EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N'AdventureWorks2012';  
GO

See Also

About Log Shipping (SQL Server)
System Stored Procedures (Transact-SQL)