---
title: "sp_delete_log_shipping_primary_database (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "06/10/2016"
ms.prod: sql
ms.prod_service: "database-engine"
ms.reviewer: ""
ms.technology: system-objects
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
author: MashaMSFT
ms.author: mathoma
---
# sp_delete_log_shipping_primary_database (Transact-SQL)
[!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md](../../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.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](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)  
  
## 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)](../../database-engine/log-shipping/about-log-shipping-sql-server.md)   
 [System Stored Procedures (Transact-SQL)](../../relational-databases/system-stored-procedures/system-stored-procedures-transact-sql.md)